Re: Source size and how to change

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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: Ignore & continue for ADO field is too small errors
    ... Anyway, while working in ADO recently, I ran into ... Now, I could put in a check to see if the field is text, check that the string ... 'fetch' query), and tries to track what has been changed so it knows ... A simple Len and Mid call to truncate a string shouldn't have that ...
    (microsoft.public.vb.general.discussion)
  • 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)
  • Re: Ignore & continue for ADO field is too small errors
    ... I'm somewhat new to ADO, so Update seemed to make the most ... I've made a simple truncating that checks if the field type is a string, ... is greater than the DefinedSize, then truncate the text to the DefinedSize, ... 'fetch' query), and tries to track what has been changed so it knows ...
    (microsoft.public.vb.general.discussion)