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 1,866 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,587 09-04-2014, 06:43 PM
Last Post: anshika.agarwal
Rolleyes Browse object query Hema a newbie 0 1,689 07-22-2014, 08:37 PM
Last Post: Hema a newbie
  SQL Query Issue in QTP rajiv.qtp 1 2,272 11-28-2013, 10:36 AM
Last Post: Jay
  Do recordsets get to use only ONE query? Arena 0 2,106 04-03-2012, 07:08 PM
Last Post: Arena

Forum Jump:


Users browsing this thread: 1 Guest(s)