I would like to assign the result of an SQL request in a script variable:
SELECT CONCAT(id,';') AS idlist
How do I assign idlist value (for example '1;5;7;10') to var?
I tried var=idlist but get an empty result.
CONCAT(id,';') AS idlist
LET var = Peek('idlist');
This will place the last loaded value of idlist into the variable 'var'.
Hope this helps,
Retrieving data ...