On Wednesday, 16 May 2001 02:15:14 UTC+7, Jeanette Weldon  wrote:   
   > what I need to do is show an error message on a visual basic form and force   
   > the user to enter a specific field if it is null in certain cases when the   
   > user commits the record.  I cannot make the column mandatory as it must only   
   > be populated in certain cases.  The user is using a visual basic form on an   
   > oracle 8i database.  I do not have access to the visual basic form source   
   > code so I thought I'd try and write an oracle database trigger.   
   >   
   > below is my database trigger  but I get a run-time   
   > error against the RAISE_APPLICATION_ERROR line.   
   >   
   > CREATE OR REPLACE TRIGGER  sdc_moa_db_trigger   
   > BEFORE INSERT OR UPDATE OF ae_mode_of attendance   
   > ON application_events   
   > FOR EACH ROW WHEN (new.ae_mode_of_attendance   
   >                                         IS NULL   
   >                                         AND new.ae_evt_ref_no != '100')   
   > BEGIN   
   >       RAISE_APPLICATION_ERROR(-20000,);   
   > END;   
   >   
   > Jeanette   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)