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?
Printable View
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?
Hi Joseph,
Use the line continuation character '_' and continue your query on the next line.
Cheers...
Thank you for replying:)
I tried it and it did not work for me. Can you provide me with an example?
thank you
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....