+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: Pass "/" in Query string to DB (/Thread-Pass-in-Query-string-to-DB)
Pass "/" in Query string to DB - Anjali09 - 01-04-2012
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