UPDATE

FUNCTION

This command combines capabilities of ADD, DELETE, and CHANGE commands. It is syntactically similar to the CHANGE command.

SYNTAX

UPDATE link-name function[USING key-file-access][index-file-access]
      [MISSING KEY[PROCESS IS] procedure]
      [BUSY[PROCESS IS]procedure]
      [END[PROCESS IS]procedure]
      [ERROR[PROCESS IS]procedure]
      [SELECT[WHEN]condition][PROCESSING[IS]procedure]
      [TEXT"text-id"[WINDOW window-options]]
      [RETRY[IS]retry-code-string]

function

select one of the following:

"A"	Add record. Record range/access not valid.
"U"	Change record. Record range/access valid.
"D"	Delete record. Record range/access not valid.

NOTES

• With OPENworkshop the UPDATE command is supported by the Script-IV language.
• The UPDATE command provides a new function string. This string indicates whether the UPDATE command is to “A” ADD, “U” Change, or “D” DELETE the specified record(s).
• The UPDATE command also supports two new areas of Script functionality: Link I/O Trigger Processing and Format-based Delete Values Processing and Audit Processing
• Comparison of functionality:

Note

Format Delete Values	Format-Based Audit	Link I/O Trigger
Yes	Yes	No
Yes	Yes	Yes
N/A	No	No
N/A	No	No
No	No	No
Yes	Yes	Yes
:::

EXAMPLES

UPDATE OELINVH "U"         ! Change sales rep and/or
      USING KEYK SORT1     ! customer key for all
      RANGE FROM OLDK$     ! invoice records
         TO OLDK$          ! using old

PROCESSING IS INVHUPDATE      ! customer key.

From the Script-IV Language Reference, version 8.9.1. Open this page in the PDF