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: 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)
  • 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 ... which performs the record insertion. ...
    (microsoft.public.sqlserver.programming)
  • Re: Using a ComboBox selection to complete 3 text boxes. Please Help
    ... Although you know that it is a SQL statement, ... just a string. ... 'recognised' object like DAO, ADO or DoCmd, that VB knows ... Gerald Stanley MCSD ...
    (microsoft.public.access.forms)