Hi,
Got the following setup:
- button on a form
- when button is clicked:
- A DataBase transaction is started
- A new record is created
- The new record is shown in a formindialog (the form is in record view)
- on the form in dialog is a cancel button
- when the cancel button is clicked, the following happens
- the formindialog has to be closed
- the transaction needs to be rolled back
Now the issue is the following:
whether or not I roll back the transaction first and then close the formindialog or do it vise versa, Servoy tries to save the new record. This causes an error, since some of the columns of the table of the new record are defined as not nullable and no value has been filled yet for it.
This in no issue prior to RC3 as Servoy would fill 0 or '' into the columns, but since RC3 this doesn't happen anymore.
How should I solve this?
Paul