Difference between revisions of "ONROLLBACK Table Constraint"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 1: Line 1:
=ONROLLBACK=
 
 
 
==Class==
 
Table Constraints
 
 
 
 
==Purpose==
 
==Purpose==
 
Table constraint activated when a forms based operation is abandoned
 
Table constraint activated when a forms based operation is abandoned

Revision as of 15:18, 29 October 2009

Purpose

Table constraint activated when a forms based operation is abandoned


Syntax

ONROLLBACK <procedure>


See Also

ALTER TABLE, CONSTRAINTS, CREATE TABLE


Description

A constraint is used to define rules that help to provide data integrity. TABLE constraints apply to table-based operations. You must have ALTER privilege on the table. The table will be locked for EXCLUSIVE use during the operation.

The ONROLLBACK table constraint is activated when a forms based operation is abandoned. The <procedure> specified must be a character expression evaluating to a procedure name. If no file extension is included, '.prg' is assumed. The specified procedure is run when the user presses the [ABANDON] key.


Example

ALTER TABLE customer modify ONROLLBACK "p_rollback";


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer