-
Junior Member
QTP script using Multiple Line SQL query
I have a multiple line SQL query to put in my QTP script. How can I keep the query in a multiple line format int the (QueryStr="") instead of one single line?
-
Expert Member
Re: QTP script using Multiple Line SQL query
Hi Joseph,
Use the line continuation character '_' and continue your query on the next line.
Cheers...
-
Junior Member
Re: QTP script using Multiple Line SQL query
Thank you for replying
I tried it and it did not work for me. Can you provide me with an example?
thank you
-
Expert Member
Re: QTP script using Multiple Line SQL query
Hi Joseph,
Here is an example of a line in my code -
objRecordset.Open "SELECT * FROM Hardware" , objConnection, _
adOpenStatic, adLockOptimistic
Set colSoundCards = GetObject("winmgmts:").ExecQuery ("Select * from RelationsTable _
where RelationID is not null")
Cheers....
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules