Re: Unwanted Message in Forms 4.0

In article <3p2vnt$lmh_at_newsbf02.news.aol.com> stowe_at_aol.com (Stowe) writes:
>From: stowe_at_aol.com (Stowe)
>Subject: Re: Unwanted Message in Forms 4.0
>Date: 13 May 1995 15:02:21 -0400
 

>In article <3oqr1k$265_at_news.sandia.gov>, Ken Brouillette <kabroui_at_envc.sandia.gov> writes:
 

>>
>>When I query a set of records into a form and attempt to scroll
>>through them using the down arrow, I get this annoying prompt after each
>>record that says "Do you want to save the changes you have made?", even when
>>no changes have been. Anybody know how to stop this? Thanks in advance
>>for your help.
 

>To be perfectly blunt, the only time I have seen this behavior is when some kind
>of programming error has been committed in the Form. There are many mistakes that
>can cause this kind of error, so it will be difficult to guess exactly what is causing it.
 

>In short, check your triggers. One or more of them is causing this behavior by
>doing something strange.

Make it a little easier on him! Any time a form field that is part of the base table is modified, forms flags the record as changed. Even if it is changed to the original value. It sounds like you have a trigger of some sort that is modifying a base table field in one of your detail blocks and scrolling through the master block is causing forms to want to save the previous changes to the detail records before getting a new detail set.

If you respond yes to the prompt, how many records does forms tell you it has updated? You can use this to find the offending block. Run without changing anything and note this number. Then change a record in one block and commit. When the number of updates stays the same instead of going up you have found the block/record that is being modified and you can start looking at the triggers around it.

Good Luck..... Received on Tue May 16 1995 - 00:00:00 CEST