Forum Discussion

mgroen2's avatar
mgroen2
Super Contributor
6 years ago

dynamic values in SQL query

Hi,

 

I have following question:

is TC able to use variables in SQL statements to check on SQL db for a value created during testing?

 

For example, I have created this SQL query. AANVRAGER has a fixed value (3261464) but in stead AANVRAGER needs to be populated by a variable (I already have captured this variable from an on screen object).

  • tristaanogre's avatar
    tristaanogre
    Esteemed Contributor
    6 years ago

    Not in a DB table definition like that.  For that, you will want to use an ADO object and write code to be able to pull the variable into the SQL query.

    • mgroen2's avatar
      mgroen2
      Super Contributor
      6 years ago

      Hi,

      thanks tristaanogre,

       

      I'll take a look at it.

       

      I would like to see this improved in TC so that no scripting is required for this!