Re: save between next/previous record

From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 1998/04/02
Message-ID: <6g0en9$c8e2_at_hendrix.csufresno.edu>#1/1


In article <35239604.59C1_at_univ-rennes1.fr>, anthony simon <anthony.simon_at_univ-rennes1.fr> wrote:
> i've two blocks in my form with master-detail type relation
>
> when i modify a text item value in the detail block (multi-records)
> and want to go to the next record of the master block (mono-record)
> forms send me the query message 'Do you want to commit the change
> you have made - YES NO CANCEL' before going to the next record
>
> Ok for that
>
>
> but if i do a change in the master block and want to go to the next
> record, i haven't the message, forms go directly in the next
> record. I would like have the message before going to the next
> record coz i don't want allow the navigation in the different record
> without save modifications between records

You can do an automatic commit_form from a when-new-record-instance in the master block, or better, in a when-timer-expired trigger for a timer that is started from a post-record trigger.

All you need is:
  If :system.form_status='CHANGED' then
    Commit_Form;
  End if;

Steve Cosner
http://members.aol.com/stevec5088 Received on Thu Apr 02 1998 - 00:00:00 CEST

Original text of this message