Foundset Synchronization with database

Classic Servoy
1

Hi

We have problems with the foundset not in sync with the database. When creating a new record (via a dialog), and then canceling the dialog (button “Abbrechen”) an empty fake record is displayed (columns “Code” and “Fachschaft”), see screenshots. This record can not exist in the db, as code is the primary key and obviously there is none entered in the dialog. It’s irritating that I even can delete the record which is not in the database, but must be in the foundset (how else could I delete it?)

Anyone else having seen this when creating records?

Regards, Robert

PS: Servoy Developer 4.1.2

creating record.png
creating record.png1269×832 144 KB

cancelling record creation.png
cancelling record creation.png1270×832 175 KB

2

You say you create a new record in a dialog and then the user cancels the dialog. I think you need to be more specific about the internals of your code.

Are you using transactions, is autosave on or off, what is the code you fire when the user cancels the dialog to remove the record that was created in the dialog etc. etc.

Paul