|
This command combines the update instruction from the parameters of the 'update' and 'where' commands and performs an update. |
||||||
![]() |
This command must not be called in a conditional instruction. Please note that other than with the update_ent', 'update_ref', and 'update_typ' commands - all records are modified which match the corresponding Where statement! Access rights and locking conflicts (simultaneous access by several users) are not checked. System attributes of the changed data records are not updated and no integer check is carried out! |
||||||
Syntax: |
|||||||
exec_update() | |||||||
I/O parameters:
|
|||||||
Return value: |
|||||||
|
|||||||
Return code: |
|||||||
|
|||||||
Example: |
|||||||
Declaration of Variables | |||||||
10 PRO_NAME="Example Project #3" 20 update (PRO_NAME) 30 where ("T_PRO_DAT.PROJ_ID"="XJ500") 40 exec_update() Declaration of Variables: PRO_NAME S "T_PRO_DAT.PROJ_NAME" |
|||||||
Result: The project name "Example Project #3" is assigned to the "PROJ_ID "XJ500" record. The update is performed on the database layer. |
|||||||
![]() |
Functions and commands: DB / Mask Interface |