Re: PLEASE HELP: commit Problem in Forms 4.5

John Strange wrote:
>
> Add a pre-insert trigger to fill in your field key.
> select your_sequence_name_here.nextval into your_field
> from dual;
>
> Any user entered fields can be tested with a
> when_validate trigger under each item.
>
> Keep the form simple. Let the user commit.

I would agree with John. Keep the form simple. Auto-committing can lead to several problems down the line. Another trigger you could use would the the WHEN-DATABASE-RECORD. Keep in mind this only fires ONCE - then it has been determimed that the record will indeed be either an insert or update to the database. I have use this and the PRE-INSERT triggers to do default processing.

ken. Received on Fri Sep 26 1997 - 00:00:00 CEST