Do you want to save changes?
Carla Vaz
I惴 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扉e already changed the default procedure generated by the developer
when relations between blocks are created - Clear all master details. In
this procedure i扉e 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 carl...@ncubo.pt
Alan D. Mills
I'd start with the POST-QUERY trigger. Presumably something, somewhere is
being changed for you and if you're not doing it by hand then I'd start with
the post-query trigger as a likely suspect. Examine this trigger and follow
it through to see what is being set and when. Hopefully you'll find that
some base table fields is being modified (maybe to its own value?).
--
Alan D. Mills
Carla Vaz wrote in message <35A0DB3A...@ncubo.pt>...
Nuno Guerreiro
On Mon, 06 Jul 1998 15:12:10 +0100, Carla Vaz <carl...@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 carl...@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
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 <carl...@ncubo.pt>
> wrote:
>
> >I惴 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扉e already changed the default procedure generated by the developer
> >when relations between blocks are created - Clear all master details. In
> >this procedure i扉e 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 carl...@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: pla...@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.
Nuno Guerreiro
<plarsen...@dc.dynares.com> wrote:
>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.
>
OK, I sort of mixed up things. Of course, the Runtime will ask for
changes to be saved only if the user made changes (either directly
through the keyboard or through programmer-coded triggers).
Thanks for the clarification.
Nuno Guerreiro