Assign SQL result to script variable

[#1]

Hi,

I would like to assign the result of an SQL request in a script variable:

SET var='';

SELECT CONCAT(id,';') AS idlist

FROM table;

How do I assign idlist value (for example '1;5;7;10') to var?

I tried var=idlist but get an empty result.

Thanks

[Jason_Michaelides]

LOAD

     idlist

;

SQL SELECT

     CONCAT(id,';')     AS     idlist

FROM table;

LET var = Peek('idlist');

This will place the last loaded value of idlist into the variable 'var'.

Hope this helps,

Jason