Assign value to variable in load time

[jvitantonio]

Hi,

I'd like to know if it if possible to make a query to a DB and assign a value return from the query to a variable while a script is being executed?

[luciancotea · Accepted solution]

Use PEEK() function. See help for example.

[jvitantonio]

Thanks. I used it like this:

Temp:

load FIELD;

;

sql select FIELD from TABLENAME

;

LET variable = PEEK('FIELD');