Then can I assume that the statement "they run just after the action" can be read as "they run just after the action completes successfully"?
William -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of A. Razzak Memon Sent: Thursday, February 20, 2003 1:28 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Trigger question - Razzak's Reply At 01:15 PM 2/20/2003 -0800, William Mason wrote: >Does anyone know if an AFTER trigger fires if the >INSERT/UPDATE/DELETE command fails? William, Here is the answer to your question, including the explanation on New "AFTER" Trigger in The Glorious R:BASE 2000 (ver 6.5++), Build:1.864xRT03. The current triggers are all "BEFORE" triggers in that they run just before the actual insert, update, or delete and give you the ability to abort the action. The new triggers are "AFTER" triggers in that they run just after the action. Since the modified data has been 'committed" you cannot abort the action in an AFTER trigger. The new triggers can be created by the create table command or by the alter table command. When you use the alter table command you must define the insert triggers in the same command. The same goes for update and delete. Do not use one alter table command to add the "BEFORE" insert trigger and then another alter table to add the "AFTER" trigger. Do them both in the same command. When you drop a trigger, you do not specify the "BEFORE" or "AFTER" trigger. The drop of the insert trigger, for example, drops both parts of they are there. LIST TRIGGERS and UNLOAD command has also been updated to include these changes. Enjoy the POWER of R:BASE and make sure to have fun! Very Best Regards, Razzak.
