|
This command is used to specify the database table fields to be selected in a catenated Select instruction ('select', 'where', 'order_by', 'exec_select') and defines the variables to assign these field contents. |
|||
![]() |
This command must not be called with a conditional instruction. | |||
Syntax: |
||||
select({VAR_LIST}) | ||||
I/O parameters: |
||||
Return value: |
||||
|
||||
Example: |
||||
Declaration of Variables | ||||
10 select (DOCU_STRING_1_DB) 20 where ("T_MASTER_DAT.PART_ID"="TEST%") 30 RES=exec_select(1) 40 put(DOCU_STRING_1_DB) |
||||
Result: | ||||
A selection menu with all item IDs starting with "TEST" is displayed. After selecting an option the name of the item is displayed. | ||||
![]() |
Functions and commands: DB/Mask Interface |