QTP script using Multiple Line SQL query

[Joseph07]

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?

[bizzzzzare]

Hi Joseph,

Use the line continuation character '_' and continue your query on the next line.

Cheers...

[Joseph07]

Thank you for replying

I tried it and it did not work for me. Can you provide me with an example?

thank you

[bizzzzzare]

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....