07-23-2012 12:40 PM
Hello,
In Teststand 3.1, I try to get the MAX of a column called Col1 in the table myTAB.
To do that; I have writen in the Open Statement the following request
SELECT MAX(myTAB.Col1) FROM myTAB" Thanks. Correct execution in teststand
Question : How do I get the result with the SQL Action Step
Thank you by advance for your help
Solved! Go to Solution.
07-24-2012 02:10 AM
You should try: SELECT MAX(myTAB.Col1) as locals.MAX FROM myTAB (locals.max would be a TestStand variable)
07-24-2012 03:14 AM
Hello Rodéric,
Thank you very much for the answer.
I tried your suggestion as it is but unfortunatelly Teststand gives back an error because it can't manage correctly the locals.max in the request.
However I tried other may your idea of using the key word "as" :
First I use :
Open Statement : SELECT MAX(myTAB.Col1) as MAXI FROM myTAB
I don't know how teststand manage the "variable" MAXI.
But when I secondly add the step
SQL Action : Get - Retrive Values from record with as Column/Parameter Values:
Name/Number : "MAXI"
Values : Locals.Max
It works correctly
Thank you a lot
Ham
07-24-2012 03:42 AM
Glad I could be of some help!