Re: Forms 4.5 Question

Hi Paul,

I think you need the pre-insert and pre-update triggers to be sure your code gets executed.
Your when-button-pressed trigger does only really need the following:

if :system.form_status = 'CHANGED'
then

   commit_form;
end if;

During the commit processing, the pre-insert and pre-update triggers will fire per record as needed.

regards,

Pieter.

Paul Hancock wrote:

> I have a block of PL/SQL code that runs when the user presses a SAVE button
> (WHEN-BUTTON-PRESSED trigger).
>
> The button's function is to commit changed data to the database, but has an
> extra piece of functionality hence the PL/SQL block.
>
> My problem is, if the user navigates off the record he has changed, to
> another record, a default forms alert pops up saying "do you wish to
> commit the changes you have made"
>
> This is fair enough, and I want this alert to continue appearing, but the
> question is, how do I get my PL/SQL block that is in my SAVE BUTTON to also
> run if the user replies YES to this alert.
>
> All help appreciated.
>
> Paul.
Received on Sat Oct 16 1999 - 02:40:13 CEST