I m trying to run a query thru winrunner using db_execute_query() function.
The query is what i wrote is a complex query i.e.,a subquery. when i try to execute it is saying "The string is too long".
Can any one tell me how to proceed??
try breaking the query into parts
query1 = "select";
query2 = "from";
query3 = "tablename";
ok poor example but you get what I mean. Then you will have to concatenate them back together in the db command
Or....thinking unconventially here... Take your query and place it into a stored procedure in your db. Then you can call your stored procedure with the appropriate paramaters. This should result in a substantially shorter query string length.
Replace ineffective offshore contracts, LoadRunnerByTheHour. Starting @ $19.95/hr USD.
Put us to the test, skilled expertise is less expensive than you might imagine.
Twitter: @LoadRunnerBTH @PerfBytes
Thanks man!!!!!!!!! U rock dude!!!!!!!!