01-04-2012, 08:34 PM
Hi,
I want to pass a query to DB through QTP, which contains "/" .
eg.:
strQuery="select (SUM (abc*xyz)/sum(abc)*100) as from...."
while executing the above query, i got "Unspecifoed error" at point where call is made to DB to exceute the query.
objRecordSet.Open strQuery,objDB
when division symbol is removed its working fine.
Please let me know if somebody knows how to perform the division in sql queries.
PS: query is working fine if executed directly in DB env.
Thanks,
Anjali
I want to pass a query to DB through QTP, which contains "/" .
eg.:
strQuery="select (SUM (abc*xyz)/sum(abc)*100) as from...."
while executing the above query, i got "Unspecifoed error" at point where call is made to DB to exceute the query.
objRecordSet.Open strQuery,objDB
when division symbol is removed its working fine.
Please let me know if somebody knows how to perform the division in sql queries.
PS: query is working fine if executed directly in DB env.
Thanks,
Anjali