Re: Source size and how to change
From: Val Mazur (group51a_at_hotmail.com)
Date: 04/24/04
- Next message: Val Mazur: "Re: Row cannot be located for updating"
- Previous message: Val Mazur: "Re: Updating a database via oledb or odbc adapters."
- In reply to: TLowe: "Source size and how to change"
- Next in thread: Jerry Pisk: "Re: Source size and how to change"
- Reply: Jerry Pisk: "Re: Source size and how to change"
- Messages sorted by: [ date ] [ thread ]
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 > > > > >
- Next message: Val Mazur: "Re: Row cannot be located for updating"
- Previous message: Val Mazur: "Re: Updating a database via oledb or odbc adapters."
- In reply to: TLowe: "Source size and how to change"
- Next in thread: Jerry Pisk: "Re: Source size and how to change"
- Reply: Jerry Pisk: "Re: Source size and how to change"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|