Ask a Question

Specify a variable in SQL Designer

SOLVED
jrussell
Occasional Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
A_Roskoshnyi
Contributor

Re: Specify a variable in SQL Designer

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)

View solution in original post

2 REPLIES 2
A_Roskoshnyi
Contributor

Re: Specify a variable in SQL Designer

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)

View solution in original post

tomford51
Member

Re: Specify a variable in SQL Designer

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.

cancel
Showing results for 
Search instead for 
Did you mean: