Re: oracle 8i database trigger - showing error message on a visual basic form

[Quoted] 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,<message>);
> END;
>
> Jeanette
Received on Thu Apr 27 2017 - 11:55:56 CEST