Re: Forms 3.0.16 Caution message

From: Jennifer R. Amon <bamon_at_ocvaxc.cc.oberlin.edu>
Date: Thu, 30 Dec 1993 17:09:58 -0500
Message-ID: <bamon-301293170959_at_amon.cc.oberlin.edu>


In article <qN9BFc1w165w_at_sytex.com>, sullivan_at_sytex.com (mike sullivan) wrote:

> Forms 3.0.16, DBMS 6.0.36
>
> [background explanation omitted for brevity]
>
> Question: When I go to page two, I always get a CAUTION: Do you want to
> commit the changes you have made? Is there any way to avoid this pop-up
> page from appearing? I really am not changing any values in either block
> 1 or block 2.

                       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Yes, you are, or you wouldn't get the message. You need to check your triggers that are handling the retrieval of non-database data to see if you are maybe writing the same value over top of a queried value somewhere.

You can narrow this down by putting debug messages in your triggers that say things like "changing block1.field2" or something else equally meaningful.

I have a little procedure called debug_message, that only writes a message if a global variable is set in key-startup. That way, I don't have to keep inserting and taking out the debug messages, and if I do ultimately want to delete them all, they are easy to find.


Jennifer R. Amon            PHONE: (216) 775-6987
Houck Computing Center        FAX: (216) 775-8573
Oberlin College
Oberlin, OH 44074        INTERNET: bamon_at_ocvaxc.cc.oberlin.edu
_____________________________________________________________________
Received on Thu Dec 30 1993 - 23:09:58 CET

Original text of this message