Re: Forms 4.5 Question - HELP!!!

[Quoted] [Quoted] Do that in the trigger 'key-up' or 'key-down' (if the user use that keys to navigate)
Commit_form is a restricted procedure. You can't use it every where. Cehck your help files.

pol15_at_my-deja.com a écrit dans le message <8ebke8$9da$1_at_nnrp1.deja.com>...
>
>
>I want to detect if a user has "changed" a record before he navigates
>"off" of it onto a different record, and give him the option to "save"
>or not. ie. I want to give the option "Do you wish to save the changes
>you have made? YES/NO/CANCEL".
>
>I want this alert to appear BEFORE the user actually navigates to the
>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
>I get the error "FRM-40737: Illegal restricted procedure COMMIT in POST-
>RECORD trigger" if the user chooses to "save" their changes.
>
>NOTE: Oracle Forms produces a similar default alert when there are
>unsaved changes to the current record set if the user tries to re-
>query. I am trying to avoid this automatic message appearing by getting
>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