|
This function will retrieve a field value
from the resulting SQL statement. If multiple records are returned,
LOOKUP will return the 1st value.
LOOKUP(Field , SQL , Server)
PARAMETERS
Field
The field whose value you wish to
retrieve
SQL
The SQL statement
Server
The Server used to query against .. use --- for the local
device
EXAMPLE:
To
retrieve the value of FIELD1 from the table MYTABLE where Field2 = 'TEST'
and save that value in the control referenced by tag
~mytext~:
SETVALUE(~mytext~//LOOKUP({field1},"SELECT
* FROM mytable WHERE field2 =
'TEST'","---")) |