Razzak, RBDOS 1.866xRT03
Dennis --- "A. Razzak Memon" <[EMAIL PROTECTED]> wrote: > > 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. > >================================================ >
