parameterized SQL query in QTP

Thread Rating:

Thread Modes

parameterized SQL query in QTP

Saket

Super Senior Member

Posts: 1,199
Threads: 5
Joined: Nov 2008
Reputation: 0

11-27-2009, 09:44 AM

I guess the field Id1 and Id2 is expecting a numeric value
have you tried removing the single quote (')?

Code:
select * from table where id1="& x & " and id2=" & y

Find

« Next Oldest | Next Newest »

Messages In This Thread

RE: parameterized SQL query in QTP - by Saket - 11-27-2009, 09:44 AM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Exe invoked through UFT is unable to access IIS and SQL Server service	bkdevise	0	2,147	08-25-2015, 05:49 PM Last Post: bkdevise
	Query regarding "Call" statement	anupam4j	1	2,029	09-26-2014, 01:46 PM Last Post: vinod123
	parameterize Excel Sheet Name in SQL	bjitsidhu	0	2,909	07-20-2014, 08:34 AM Last Post: bjitsidhu
	Is there a possible way to execute sql in QTP using 'WITH' clause	shruthic	0	3,103	04-26-2014, 11:42 PM Last Post: shruthic
	Data Table Query	Suma Parimal	4	4,768	01-21-2014, 12:50 PM Last Post: Suma Parimal

Users browsing this thread: 5 Guest(s)