Re: Source size and how to change

From: Val Mazur (group51a_at_hotmail.com)
Date: 04/24/04 

Date: Fri, 23 Apr 2004 22:36:44 -0400

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: Insert date into a datetime column in Visual Basic 2008
    ... Dim cmdString As String ... Dim dte As System.DateTime ... wholly contained within the SQL executed on the server. ... ADO, not ADO.Net, so I can't provide a working example for you). ...
    (microsoft.public.data.ado)
  • Re: Compact SQL Database and ADO
    ... I've since made this change to the code for 'N' in front of the string. ... What happens when you change the working SQL statements to the ones I ... I haven't used SQL CE with ADO myself, I do still write a lot of VB6 apps ...
    (microsoft.public.data.ado)
  • RE: Auto truncate a string to be inserted to SQL table
    ... >> May I know how can I auto truncate a string to be inserted to a SQL table to ... >> might need to control this in SQL server. ...
    (microsoft.public.sqlserver.programming)
  • Getting Started
    ... I'm trying to get to grips with MS SQL and ADO at the same time. ... got a working method of adding a record to a table with unique ... function TMSSQLImporter.AddLocation(const Location: string): Integer; ...
    (borland.public.delphi.database.ado)
  • Executing stored procedures as CommandType=Text
    ... I don't think it is problem of sql query. ... You might need to check the connection ot connection ... >'p3'" that execute on a VB 6 application and ADO. ... >I receive the SQL requests in the string format with all ...
    (microsoft.public.dotnet.framework.adonet)