SET UPDATE

Purpose

Specify forms mode to be query or update

Syntax

SET UPDATE ON | OFF | (<expL>)

See Also

ACCESS(), BROWSE, CHANGE, EDIT, Function Keys, GETGID(), GETUID(), QUERY, SET QUERYMODE, SET STATUS

Description

If SET UPDATE is ON, current records are locked for updating in CHANGE, EDIT or BROWSE screen editing forms. This prevents other users from updating current records at the same time. When in a form, records can be locked for update by pressing the [UPDATE MODE] key in the form. While scanning through the records in a table, particularly in the BROWSE command, it is advantageous to toggle between update mode and query mode. When update mode is ON, ’Upd’ is displayed in the third section of the status bar. If the currently selected table, is open with read only access, then ’RO’ is displayed in the third section of the status bar. Attempts to toggle into update mode will cause the terminal bell to sound.

You can use the SET UPDATE OFF command in conjunction with the SET QUERYMODE command to provide read only access to a table. The GETGID() function can also be used with these commands to identify the group to which a user belongs before restricting access to a table. By default, UPDATE is ON.

Example

if getgid()>10
    set update off
    set querymode off
endif
browse

Products

Recital