How to pass long string as input to QTP

[Anjali09]

Hi,

I am trying to pass Db queries as input parameters to BPT components.
For queries longer that 1026 Char, i am getting error, as QTP accepts only 1026 character from the query string and truncate rest string.

Is there any way to increase the lenght of the string that can be passed tp QTP.
Or any other work around, to pass the complete query.

I am passing this query string as an input to the ADODB object.

Thanks in advance,
Anjali

[Vaasu]

Try to pass the entire SQL Query in single line. I have SQLQueries, those were really long and I am sure they are more than 1026 character limit. I did concatenate the entire query in single line string, it did work properly.

SQLQuery = "Select * from ................................................................................"

[Anjali09]

Hi Vasu,

Thanks for the reply.

I tried passing the whole query in one string, even by that its taking 1026 characters only.

Thanks,
Anjali

[vinod123]

Use Database Testing Wizard in Qtp

Thomas Vinod