Re: Doing Validation before Commit

Great!

so let's suppose I put this code in a procedure called Test_Before_Save

BEGIN
    .. your code here
 EXCEPTION
    WHEN <some_condition> THEN
      .. whatever you wish
 END; Now where can I call the Test_Before_Save procedure from?

Should I do it from the KEY-COMMIT trigger on the form level or from the KEY-COMMIT trigger on the detail datablock level or from the master datablock level.

Or should I call it from another trigger like POST-FORM...

Regards,

Elie,

DA Morgan <damorgan_at_x.washington.edu> wrote in message news:<1101998063.564651_at_yasure>...
> elie.constantine_at_gmail.com wrote:
> > Ok... Sorry for any inconveniences.
> >
> > The FORM_TRIGGER_FAILURE call will be in the procedure.
> > But from which trigger I should make a call to this procedure. In the
> > POST-FORM, KEY-COMMIT, ON-COMMIT.....????? This procedure can also be
> > written to post the details data block, do the check then in case some
> > rules were not met raise the error and prohibit the data in both master
> > and detail blocks from been committed.
> >
> >
> > Regards,
> > Elie,
>
> No ... it is a procedure not a trigger. Write:
>
> BEGIN
> .. your code here
> EXCEPTION
> WHEN <some_condition> THEN
> .. whatever you wish
> END;
Received on Sat Dec 04 2004 - 13:03:48 CET