Difference between revisions of "ONROLLBACK Table Constraint"
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==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
