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


Messages In This Thread
Pass "/" in Query string to DB - by Anjali09 - 01-04-2012, 08:34 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Pass reference to datatable into function smallsteve 2 2,088 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,754 09-04-2014, 06:43 PM
Last Post: anshika.agarwal
Rolleyes Browse object query Hema a newbie 0 1,807 07-22-2014, 08:37 PM
Last Post: Hema a newbie
  SQL Query Issue in QTP rajiv.qtp 1 2,486 11-28-2013, 10:36 AM
Last Post: Jay
  Do recordsets get to use only ONE query? Arena 0 2,191 04-03-2012, 07:08 PM
Last Post: Arena

Forum Jump:


Users browsing this thread: 1 Guest(s)