|
This command determines the database table fields to be updated in case of a catenated Update instruction ('update', 'where', 'exec_update'). |
||||||
Syntax: |
|||||||
update({VAR_LIST}) | |||||||
I/O parameters:
|
|||||||
Return value: |
|||||||
|
|||||||
Example: |
|||||||
Declaration of Variables | |||||||
10 PRO_NAME="Test example Project 3" 20 update (PRO_NAME) 30 where ("T_PRO_DAT.C_ID"="12340000") 40 exec_update() Variable definition: PRO_NAME S "T_PRO_DAT.PROJ_NAME" |
|||||||
Result: | |||||||
The record with the C_ID "12340000" is assigned the project name "Test example Project 3". The update is performed on database level. | |||||||
![]() |
Functions and commands: DB/Mask Interface |