Forms 4.5 Question - HELP!!!

[Quoted] [Quoted] I want to detect if a user has "changed" a record before he navigates
[Quoted] "off" of it onto a different record, and give him the option to "save"
[Quoted] or not. ie. I want to give the option "Do you wish to save the changes [Quoted] you have made? YES/NO/CANCEL".

I want this alert to appear BEFORE the user actually navigates to the [Quoted] new record, as I want to remain on the old record if they choose the CANCEL option.

I know I can use the system variable ":SYSTEM.RECORD_STATUS = 'CHANGED', but I am not sure what trigger to use.

The thing is, I want to issue a COMMIT_FORM command if the user says
"yes" to save changes, and Forms doesn't like this being used in the
triggers I have tried.

For example, if I use the POST-RECORD trigger to prompt the user, then [Quoted] I get the error "FRM-40737: Illegal restricted procedure COMMIT in POSTRECORD  trigger" if the user chooses to "save" their changes.

[Quoted] NOTE: Oracle Forms produces a similar default alert when there are unsaved changes to the current record set if the user tries to requery.  I am trying to avoid this automatic message appearing by getting [Quoted] the user to commit/rollback before the default appears.

Can anyone shed any light on this problem?

All help greatly appreciated.

Pol.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Apr 28 2000 - 00:00:00 CEST