Re: Do you want to save changes?

Hi Nono (and Carla Vaz),

Your statement is NOT true.
Forms does not need to know if you want to commit changes when you exit ... only if you have outstanding changes you're asked ... if you're using the standard functionallity.
One way of avoiding that is to enter EXIT_FORM (NO_VALIDATE); as the KEY-EXIT - but I would avoid that.

If the questions keep poping up nomatter what you do, for instance if you only do a query, then you have a programming error in your form, that alters basetable items for some reason.

Alan D. Mills has a great suggestion and that's to look at POST-QUERY. If there is no query in the form, then it's most likely an WHEN-... something trigger, or a PRE-something trigger that enters data into a basetable item. And THAT is a big no-no i Forms.

• Peter H. Larsen

Nuno Guerreiro wrote:
>
> On Mon, 06 Jul 1998 15:12:10 +0100, Carla Vaz <carlavaz_at_ncubo.pt>
> wrote:
>
> >I´m working with Forms 4.5. and i have a problem!!!
> >
> >Every time i run a form i have a runtime message -- "Do you want to save
> >changes?".
> >I´ve already changed the default procedure generated by the developer
> >when relations between blocks are created - Clear all master details. In
> >this procedure i´ve changed the comand clear_block(ask_commit ) to
> >clear_block(no_validate), but still the message appears.
> >
> >Can anyone help me to get this message out of developer, please.....
> >
> >Thanks.
> >
> >My email is carlavaz_at_ncubo.pt
> >
> >
>
> Forms 4.5 Runtime needs to know if the user wants to commit the
> transaction or rollback when he/she leaves a form. If you want to save
> the information whenever the user leaves a form, write COMMIT_FORM; in
> the appropriate trigger (e.g., on a WHEN-BUTTON-PRESSED trigger on a
> "Close" button). This way the user won't be bothered with the
> question.
>
> Hope this helps,
>
> Nuno Guerreiro

--

Peter H. Larsen, Oracle and Applications specialist Dynamic Resources Inc, Alexandria
Phone: 703-914-9800 #103
Fax: 703-914-9804
Email: plarsen_at_dc.dynares.com
(please remove the nospam from the header when replying to this email)

The above views are my own and does not reflect the views of my employer. Received on Mon Jul 06 1998 - 13:51:24 CDT