Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Pass "/" in Query string to DB
#1
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,721 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 3,186 09-04-2014, 06:43 PM
Last Post: anshika.agarwal
Rolleyes Browse object query Hema a newbie 0 2,152 07-22-2014, 08:37 PM
Last Post: Hema a newbie
  SQL Query Issue in QTP rajiv.qtp 1 2,939 11-28-2013, 10:36 AM
Last Post: Jay
  Do recordsets get to use only ONE query? Arena 0 2,470 04-03-2012, 07:08 PM
Last Post: Arena

Forum Jump:


Users browsing this thread: 1 Guest(s)