Difference between revisions of "ONROLLBACK Table Constraint"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (2 intermediate revisions by one user not shown) | |||
| 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 | ||
| Line 26: | Line 19: | ||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| − | ALTER TABLE customer modify ONROLLBACK "p_rollback" | + | ALTER TABLE customer; |
| + | modify ONROLLBACK "p_rollback" | ||
</code> | </code> | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital, Recital Server |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
Latest revision as of 11:04, 22 December 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, Recital Server
