Forum Discussion

jrussell's avatar
jrussell
Occasional Contributor
3 years ago
Solved

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

  • 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)

2 Replies

  • 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)

  • 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.