Forum Discussion

dpurnima's avatar
dpurnima
New Contributor
4 hours ago

Using Dynamic SQL in TestComplete DBTable

Our application data is completely refreshed every month, so the record values/keys change. Is there a way i can make the queries dynamic in the DBTable wizard. For e.g. I want to use something like the following in the DBTable wizard.

select * from employee where account_no=?

  • rraghvani's avatar
    rraghvani
    Champion Level 3

    Try to use a variable, if it's possible. Otherwise use script code.