Teststand SQL reuest get MAX of a Column

[Hameuza]

Spoiler

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

[Rodéric]

You should try: SELECT MAX(myTAB.Col1) as locals.MAX FROM myTAB   (locals.max would be a TestStand variable)

[Hameuza · Accepted solution]

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

[Rodéric]

Glad I could be of some help!