May 2, 2001
===========================================================
>From the Edge: Which process activate first!
Section: Stored Procedures and Triggers
Platform: R:BASE 2000 (ver 6.5+) for DOS/Windows
Build: 1.839xRT03 and Higher ...
===========================================================
A trigger automatically runs a stored procedure when an
UPDATE, DELETE, or INSERT command is run with a table.
R:BASE 2000 (ver 6.5+) and higher includes many bug-fixes
and enhancements in reference to Stored Procedures and
Triggers.
The upcoming upgrade version of R:BASE 2000 version 6.5++,
build 1.840J and higher will also include the bug fix for
very old boo-boo related to leftover LOCKS with DELETE
Triggers.
Now, you all might be interested to know the sequence
in which the data integrity is maintained when using
the Stored Procedures and Triggers.
Here's the order:
DELETE
-rules
-cascades
-triggers
-keys
-row itself
UPDATE
-rules
-cascades
-triggers
-keys
-row itself
INSERT
-rules
-triggers
-keys
-row itself
More to come ...
Very Best Regards,
Razzak.
===================================-============================
R:BASE Developers's Conference: http://www.rbase.com/conference
Official R:BASE List Server: mailto:[EMAIL PROTECTED]
RBTI Events/Training: http://www.rbase2000.com/events
R:DCC Members: http://www.rbase2000.com/rdcc
================================================================
R:BASE, Oterro & R:Tango are registered trademarks of RBTI.
==================================-=============================
