Re: Source size and how to change

From: Jerry Pisk (jerryiii_at_hotmail.com)
Date: 04/24/04 

Date: Fri, 23 Apr 2004 23:26:47 -0700

Actually it does, depending on your settings ADO will truncate strings at
4000 or 8000 characters. The first is when using Unicode strings (the
default), the second when using ASCII strings.

Jerry

"Val Mazur" <group51a@hotmail.com> wrote in message
news:%23uZC9TaKEHA.4052@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> It should not truncate sql string. I am using pretty big one in some cases
> and it works fine. What is your query looks like and how do you know that
> string was truncated. Do you get any error?
>
> --
> Val Mazur
> Microsoft MVP
>
>
> "TLowe" <noelbisspam@nomindspringspam.com> wrote in message
> news:eraMmvUKEHA.1156@TK2MSFTNGP09.phx.gbl...
> > Hello all!
> > I have a question about the size of a string that can be passed as the
> > source in an ADO call. Here is recordset that I am trying to open.
The
> > problem is the variable (strSQL) holding the sql statement is truncating
> > the
> > statement. It must be happening in the ADO call because the actual
> > variable
> > has the correct value. How do I change the size of the ADO source so
> > that
> > it will allow my whole sql statement to be passed?
> >
> > Thanks for any help!
> >
> > Tom
> > Here is the ADO call
> > rs.Open strSQL, cnnConnection, adUseClient, adLockReadOnly
> >
> >
> >
> >
> >
>
>

Relevant Pages

  • Re: Having problem with SQL statement - error no value given
    ... opportunity to promote a way of using it to overcome 2 ... secondly the entry of text strings containing quotes ... Using the original example, declare a ADO command object, ...
    (microsoft.public.access.forms)
  • Re: copyFromRecordset - vs - getRows
    ... ADO will make a best-guess at the data type, and it must be thinking these ... > array before populating the range in the worksheet results in the strings ... > My knowledge of SQL is limited, and I can't see anything in the recordset ... > my current workarround is to write the data with .copyFromRecordset, ...
    (microsoft.public.excel.programming)
  • Re: INSERT Delay
    ... ADO sees them as a transaction (my bad for using the word ... Create a program that uses an ADO connection to SQL Server. ... Concatenate the three strings together with a CRLF between them. ... If they are not handled as a transaction, the first two should be committed ...
    (microsoft.public.sqlserver.programming)
  • Re: Source size and how to change
    ... those are limits of SQL types nvarchar and varchar ... the second when using ASCII strings. ... >> It should not truncate sql string. ...
    (microsoft.public.data.ado)
  • Re: can i extend the default limit of 256 bytes on memo fields?
    ... that will truncate long text strings to 255 characters. ... action/method; it will not truncate long text strings. ... warning messages of field truncation on my memo-type field. ...
    (microsoft.public.access.externaldata)