| || |
Struck with db_execute query
I am trying to get text from a edit box and use that as a run time parameter inside db_execute_query.For that i created a statement like this..
db_execute_query("Query","PREPARE usrplan static) AS SELECT trail.name, trail.trail_type FROM informix.trail trail WHERE trail.name LIKE $1",record_number);But it fails to execute.
is there any better ideas [img]graemlins/blankface.gif[/img]
Re: Struck with db_execute query
The PREPARE statement is unique to dynamic SQL. I don't think this is supported by WinRunner. I would reccomend building your SQL string first, then passing this string to db_execute_query. Some thing like:
db_execute_query("Query","SELECT trail.name, trail.trail_type FROM informix.trail trail WHERE trail.name LIKE '" & text & " %'",record_number);