parameterized SQL query in QTP

[sk.aravind]

I ve got a problem

as soon as i create a record in my GUI an 2 unique ids are generated for a record and it is displayed at the bottom of my screen

I retreived the values using text output values

Now i need to validate whether the record is present in the database

I stored the 2 ids in the variables x & y respectively

in the Database output value I mentioned the sqlquery as

select * from table where id1='x' and id2='y'
I used the select SQL statement manually after setting up the connection string
The database ouput value Wizard throws an error.

Kindly help me out in this

how do i use output values as input to SQL

[Jackomcnabb]

Try this

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

[sk.aravind]

Hi Jack

I did try this

I get an error stating that SQL query cannot be excecuted

details :[Microsoft][ODBC driver for Oracle][Oracle]ORA-01722: invalid number

[sk.aravind]

Hey guys

can someone help me out on this

[Saket]

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

[sk.aravind]

I HAVE DONE IT BUDDY. I will try once again and get back to u

[sk.aravind]

it says "invalid identifier" now for this query

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

tried all possible combinations . no sloution yet

[v_selvam]

Hi,
Check, the id1 and id2 column's data type. According to it, you reframe your query and then try.