Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Pass "/" in Query string to DB
#1
Not Solved
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
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Pass reference to datatable into function smallsteve 2 2,068 09-28-2017, 09:18 PM
Last Post: smallsteve
  Can you please help me in QTP DP to pass the variable name anshika.agarwal 1 2,740 09-04-2014, 06:43 PM
Last Post: anshika.agarwal
Rolleyes Browse object query Hema a newbie 0 1,797 07-22-2014, 08:37 PM
Last Post: Hema a newbie
  SQL Query Issue in QTP rajiv.qtp 1 2,474 11-28-2013, 10:36 AM
Last Post: Jay
  Do recordsets get to use only ONE query? Arena 0 2,184 04-03-2012, 07:08 PM
Last Post: Arena

Forum Jump:


Users browsing this thread: 1 Guest(s)