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

1 REPLY 1
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

cancel
Showing results for 
Search instead for 
Did you mean: