Difference between revisions of "SET DELETED"

From Recital Documentation Wiki
Jump to: navigation, search
Line 1: Line 1:
=SET DELETED=
 
 
 
 
==Class==
 
==Class==
 
Fields and Records
 
Fields and Records
Line 15: Line 12:
  
 
==See Also==
 
==See Also==
[[DELETE]], [[RECALL]], [[DELETED()]], [[SET FILTER]]
+
[[DELETE]], [[DELETED()]], [[RECALL]], [[SET FILTER]]
  
  
Line 23: Line 20:
  
 
==Example==
 
==Example==
<pre>
+
<code lang="recital">
 
set deleted on
 
set deleted on
use patrons</pre>
+
use patrons</code>
  
  

Revision as of 14:24, 15 April 2009

Class

Fields and Records


Purpose

Determine whether or not records that are marked for deletion are hidden


Syntax

SET DELETED ON | OFF | (<expL>)


See Also

DELETE, DELETED(), RECALL, SET FILTER


Description

If SET DELETED is ON, then records that have been marked for deletion are ’invisible’. Records can be marked for deletion with the DELETE command or the DELETE key, and recalled with the RECALL command or the DELETE key. Deleted records can be recalled until a PACK command is issued on the table. By default, DELETED is OFF in Recital Terminal Developer and ON in Recital Server products.


Example

set deleted on
use patrons


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer