Thanks Larry, That got me the after trigger I needed.
I can immagine lots of scenarios where both a before trigger and an after trigger would be desirable. One might want to do before processing on some columns and after processing on others. Anyone know for sure the real scoop on this? Dennis McGrath --- Lawrence Lustig <[EMAIL PROTECTED]> wrote: > > I used the syntax acording to RSyntax.com : > > ALTER TABLE Student ADD TRIGGER + > > UPDATE BEFORE beforepro, + > > UPDATE AFTER afterpro > > Dennis: > > I don't know if you can have both a before AND after > trigger on the same event. However, to create a > BEFORE trigger, do NOT include the keyword BEFORE: > > ALTER TABLE Student ADD TRIGGER + > UPDATE BeforePro > > but > > ALTER TABLE Student ADD TRIGGER + > UPDATE AFTER AfterPro > > -- > Larry > > __________________________________ > Do you Yahoo!? > SBC Yahoo! DSL - Now only $29.95 per month! > http://sbc.yahoo.com >
