Forum Discussion

jrussell's avatar
jrussell
Occasional Contributor
4 years ago

Specify a variable in SQL Designer

I have a Keyword test with a Database Table Checkpoint. 

Is there a way to specify a variable in the SQL designer?  I have a query that looks like this:

SELECT
Width, Length, Height
FROM Skus
WHERE SKU='12345'

 

What I want is to be able to dynamically specify a value instead of using a hardcoded value of 12345

  • A_Roskoshnyi's avatar
    A_Roskoshnyi
    4 years ago

    For as long as I know, it's not possible. So I don't use 'Database Table Checkpoint' in my tests. But I have scripts that I wrote myself to read and validate single values, rows or tables from database (task-dependent)

  • A_Roskoshnyi's avatar
    A_Roskoshnyi
    Contributor
    4 years ago

    For as long as I know, it's not possible. So I don't use 'Database Table Checkpoint' in my tests. But I have scripts that I wrote myself to read and validate single values, rows or tables from database (task-dependent)

  • tomford51's avatar
    tomford51
    Member
    4 years ago

    If you have problems with the design, perhaps you shouldn't bother too much, because you can look for not bad ready-made solutions on the Internet, for example. I don't like to waste time on trifles and often take a design font from here Master Bundles , there are many different options that will suit any topic.