Difference between revisions of "SET UPDATE"

From Recital Documentation Wiki
Jump to: navigation, search
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=SET UPDATE=
 
 
 
==Class==
 
Multi-User
 
 
 
 
==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==
[[BROWSE]], [[CHANGE]], [[QUERY]], [[SET QUERYMODE]], [[ACCESS()]], [[GETGID()]], [[GETUID()]]
+
[[ACCESS()]], [[BROWSE]], [[CHANGE]], [[EDIT]], [[Function Keys]], [[GETGID()]], [[GETUID()]], [[QUERY]], [[SET QUERYMODE]], [[SET STATUS]]
  
  
Line 25: Line 18:
  
 
==Example==
 
==Example==
<pre>
+
<code lang="recital">
 
if getgid()>10
 
if getgid()>10
set update off
+
    set update off
set querymode off
+
    set querymode off
 
endif
 
endif
browse</pre>
+
browse
 +
</code>
  
  
 
==Products==
 
==Products==
Recital Terminal Developer
+
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