Thanks to all - it seems that when the BEFORE clause is used the command fails, but the following works for adding both at the same time:
ALTER TABLE CurrentSite ADD TRIGGER UPDATE loginsert UPDATE AFTER logupdate wm -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Albert Berry Sent: Thursday, February 20, 2003 12:06 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Error Checking I vaguely recall a message on the list that BOTH triggers must be in the same statement when creating and updating - they are not created separately. "William Mason" <[EMAIL PROTECTED]> wrote: >Follow up - latest version of RBWin 1.864 x RT03 > > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of William >Mason >Sent: Thursday, February 20, 2003 11:47 AM >To: RBASE-L Mailing List >Subject: [RBASE-L] - Error Checking > > >Maybe I'm missing something here, but.... > >Why does this command complete - >ALTER TABLE CURRENTSITE ADD TRIGGER UPDATE AFTER TEST2 > >While this one returns "Procedure does not exist"? >ALTER TABLE CURRENTSITE ADD TRIGGER UPDATE BEFORE TEST2 > >It seems that anytime I use the BEFORE clause it fails to run. �How does one >do both in one command? > > >TIA > >William Mason > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
