How to use ADO to issue query that more than 250 characters?

  • Thread starter Thread starter Ai_Jun_Zhang
  • Start date Start date
A

Ai_Jun_Zhang

Hi!

I am using ADO to retrieve data from ACCESS DB. However, my sql is mor
than 250 characters long but the .commandText field in ADODB.Command ca
only take 250 characters. My question is: with use of ADO, how can
issue query that is longer than 250 characters long?

Please help me with this.

Thanks,

Aijun
 
Dick and Patrick,

Thank you very much for let me know that the limitation for .Commantext
is not 250 characters. It works now.

Regards,

Aijun.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO help: Only get first 255 characters of field... 2
Pass text > 255 char. to closed wkb with SQL? 1
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
How to specify a cell format for pivot data field? 3
250 Character limit on db writes? 3
SQL limit of 255 characters 2
Unable to enter more than 125 characters in text field. 2
Speeding up updating records using ADO 1

Back
Top