> 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
