Re: Ask help for oracle forms problem

GLucas4189 wrote:
> I think your last point is alluding to the efficiency of validation triggers.
> If you do violated a validation trigger, say WHEN-VALIDATE-ITEM, with good
> reason , if a raise form_trigger_failure statement has been issued, will you
> not be able to proceed.
> The only thing to do here is to relax your validation, and only give warnings
> in this context...

Additionally, you are able to clear the currently entered (invalid) data in the record using

        do_key('clear_record');
After clearing the record, you can execute a query or whatever. But be carefull, the entered data gets lost when you clear_record.

Hope this helps.

Sicco Ottne Received on Mon Oct 26 1998 - 11:28:55 CET