Lantica User Forum - Record Has Been Changed Message Mystery

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › Record Has Been Changed Message Mystery

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Page Index Toggle

Pages: 1

Send Topic

Print

Normal Topic

Record Has Been Changed Message Mystery (Read 2256 times)

PianoMan Member Members Offline No personal text Posts: 44 Joined: Oct 13^th, 2004	Record Has Been Changed Message Mystery Jan 4^th, 2005 at 9:06pm	Print Post
	In Search/Update, after viewing a record then pressing "Esc", I get the message, "The record has been changed and has not been committed to the database. Are you sure you want to close this record?" I have commented out all the programming. I have no Initial Values. I make no manual changes to the record, yet I still get the message! What other things might trigger this message?? Thank you


	WWW IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2482 Joined: Aug 20^th, 2003	Re: Record Has Been Changed Message Mystery Reply #1 - Jan 4^th, 2005 at 9:08pm	Print Post
	Hello Jon, You wouldn't happen to have any unbound combo boxes would you? -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

PianoMan Member Members Offline No personal text Posts: 44 Joined: Oct 13^th, 2004	Re: Record Has Been Changed Message Mystery Reply #2 - Jan 4^th, 2005 at 9:21pm	Print Post
	Hi Ray, Yes! I have two unbound combo boxes. Now what? Jon


	WWW IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2482 Joined: Aug 20^th, 2003	Re: Record Has Been Changed Message Mystery Reply #3 - Jan 4^th, 2005 at 9:30pm	Print Post
	Hi Jon, Well you can bind them to two new fields, at least until the next release. You can program the form on form exit to be sure that no values are retained in the combo boxes. Another way to do it would be to replace the combo boxes with regular unbound text boxes and to use one of the many Sbasic PopUps and PopupSelectPosition() -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

PianoMan Member Members Offline No personal text Posts: 44 Joined: Oct 13^th, 2004	Re: Record Has Been Changed Message Mystery Reply #4 - Jan 4^th, 2005 at 9:38pm	Print Post
	Hi Ray, Okay, I'll try to bind them, or program On Form Exit. Thank you! PianoMan


	WWW IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2482 Joined: Aug 20^th, 2003	Re: Record Has Been Changed Message Mystery Reply #5 - Jan 4^th, 2005 at 9:42pm	Print Post
	Quote: Hi Ray, Okay, I'll try to bind them, or program On Form Exit. Thank you! PianoMan Hi Jon, You will only need to program Form on Form Exit if you bind them, and do not want any values retained in the bound fields. -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

PianoMan Member Members Offline No personal text Posts: 44 Joined: Oct 13^th, 2004	Re: Record Has Been Changed Message Mystery Reply #6 - Jan 4^th, 2005 at 10:19pm	Print Post
	Hi Ray, Yes, I did just that, and the "Mystery Message" has disappeared. Thank you for your replies. PianoMan


	WWW IP Logged

Hunkulus Member Offline No personal text Posts: 12 Joined: Mar 15^th, 2005	Re: Record Has Been Changed Message Mystery Reply #7 - Mar 15^th, 2005 at 6:41pm	Print Post
	Hi Ray I have the same problem with "Record has been changed message" but I have no unbound combo boxes. Hunkulus ???


	IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2482 Joined: Aug 20^th, 2003	Re: Record Has Been Changed Message Mystery Reply #8 - Mar 15^th, 2005 at 6:53pm	Print Post
	Hello Hunkulus, Check your programming to be sure that you are not changing any values in any Form entry event. One quick way to find out if it might be your programming is to open designer, open the program layout, type some gibberish, save the layout and preview it. If the record has changed message does not appear then something in your programming is changing values. -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

Hunkulus Member Offline No personal text Posts: 12 Joined: Mar 15^th, 2005	Re: Record Has Been Changed Message Mystery Reply #9 - Mar 15^th, 2005 at 8:01pm	Print Post
	Thanks Ray This was exactly what was happening. Hunkulus


	IP Logged

Page Index Toggle

Pages: 1

Send Topic

Print

‹ Previous Topic | Next Topic ›

« Board Index ‹ Board Top

Top

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid XHTML

Valid CSS

Powered by Perl

Source Forge