Forum Discussion

baba_k's avatar
baba_k
Occasional Contributor
14 years ago

Unable to pass the variables in SQL query through test complete script

Hi, Can anyone please explain how to pass variables into SQL query through script: Below is the syntax that we are using and getting an error: Qry.SQL = "Select * from Aq1lookupalarapart whe...
AlexanderM's avatar
AlexanderM
Staff
13 years ago

Hi Juls,





In C#Script, just replace & with + :





Qry.SQL = "Select * from Aq1lookupalarapart where apar_id= " + CASID + " and dde_level_over=" + DDE_Updated_Value + " order by last_update desc"