set a variable in Script

[Anonymous]

Hi all,

Please help me with the instructionto set a variable at a script time to get (from SQL table) a variable witha max number from a field and another variable with the minimum valuefrom a field.

[sebastiandperei · Accepted solution]

Hi, in first place, you must load the table from SQL:

SQLTable:

SQL Select Distinct Field From Table;

Aux:

Load

     Max(Field) as Max,

     Min(Field) as Min

Resident SQLTable;

Let Var=Peek('Field');

Drop Table Aux;

Try and tell me how it works!!

[Anonymous]

Thanks Sebastian. worked well.