Forum Discussion

marin's avatar
marin
Frequent Contributor
13 years ago

How to dynamically set SQL query for database table checkpoint?

Hello all, I wonder if it is possible to dynamically set SQL query which is the source for DB table checkpoint? My test scenario includes data consistency check that needs to be preformed at...
Alexander_Biery's avatar
Alexander_Biery
New Contributor
11 years ago
I may be misinformed, but as far as I know, truly dynamic sql is not supported in TestComplete (bind variables or execute immediate a la Oracle PL/SQL).  It might be possible that you could build the query using a script, then concatenate variables into the statement.  However that seems like a ton of work for a feature that SmarBear should have developed long ago.



If this exists, I apologize for my ignorance.  Plz let me know how you decided to do this, or if anyone else has an idea.