Difference between revisions of "SET UPDATE"
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
(One intermediate revision by one user not shown) | |||
Line 1: | Line 1: | ||
− | |||
− | |||
− | |||
− | |||
==Purpose== | ==Purpose== | ||
Specify forms mode to be query or update | Specify forms mode to be query or update | ||
Line 32: | Line 28: | ||
==Products== | ==Products== | ||
− | Recital | + | Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] |
Latest revision as of 15:51, 25 November 2009
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