Printable View
Hi
I have a long SQL query which is to be execute through ADO
Is there any property of ADO which set the length of Query
because if i trims my query it gives me the data ,and if i use my full query then it dose'nt give the data ,though the DATa is on the table
Thanks And Regards
Ajay
Maybe when you use your full query you are adding criteria that cannot be met. Have you tried running the query directly against whatever database that you are using? I know of no limit to size of queries using ADO
Did you find the answer? I'm having the same problem. The query works against the db but not with ADO. It gets truncated at 255 chars.