Dennis,
What Version and Build of R:BASE are you using?
Very Best R:egards,
Razzak.
At 04:58 AM 6/27/2003 -0700, Dennis McGrath wrote:
Here are my findings:
This works:
ALTER TABLE TableName ADD TRIGGER UPDATE ProcName
This works, but it wiped out the BEFORE trigger:
ALTER TABLE TableName ADD TRIGGER UPDATE AFTER ProcName
This created BOTH update triggers:
ALTER TABLE TableName ADD TRIGGER + UPDATE ProcName UPDATE AFTER ProcName
I haven't tested but am I to conclude that the following syntax would create all possible triggers on the table?
ALTER TABLE TableName ADD TRIGGER + INSERT ProcName INSERT AFTER ProcName + UPDATE ProcName UPDATE AFTER ProcName + DELETE ProcName DELETE AFTER ProcName
> A table can have both "BEFORE" and "AFTER" TRIGGERs, > only one, or none. > > Typical TRIGGER Usage: > > BEFORE- data validation before the action (inventory > checks, account limit checks) > > AFTER- update of data dependent on primary keys, > automated post transaction steps. > > TRIGGERS use Stored Procedures > > Procedures are stored in the database in the system > table called SYS_PROCEDURES > > Supporting system tables are SYS_PROC_COLS and > SYS_PROC_MODS > > Hope that helps! > > If you need further details or examples of using > BEFORE and AFTER TRIGGERS, feel free to ask on > this Official List Server of R:BASE! > > Enjoy and make sure to have fun! > > Very Best R:egards, > > Razzak. >
--- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [EMAIL PROTECTED]
(Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
