ADO : Query Length

[ajay47]

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

[KMcKenzie]

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

[alex1973]

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.