Difference between revisions of "SET UPDATE"
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| (4 intermediate revisions by 2 users 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 15: | Line 8: | ||
==See Also== | ==See Also== | ||
| − | [[ | + | [[ACCESS()]], [[BROWSE]], [[CHANGE]], [[EDIT]], [[Function Keys]], [[GETGID()]], [[GETUID()]], [[QUERY]], [[SET QUERYMODE]], [[SET STATUS]] |
| Line 25: | Line 18: | ||
==Example== | ==Example== | ||
| − | < | + | <code lang="recital"> |
if getgid()>10 | if getgid()>10 | ||
| − | set update off | + | set update off |
| − | set querymode off | + | set querymode off |
endif | endif | ||
| − | browse</ | + | browse |
| + | </code> | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:Set_Commands|UPDATE]] | [[Category:Set_Commands|UPDATE]] | ||
| + | [[Category:Screen Forms]] | ||
| + | [[Category:Screen Forms Set 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
