What happens with a record that is being edited if all its fields are
empty and I do CommitRetaining of a transaction? Can I continue editing
this record or will I have problems ?
When editing a record (i.e. customer), I need to add a new language
code or a new payment condition. If this is a problem, I’d
rather have a transaction per table with the exception of tables that
must be committed together (i.e. customer balance and customerdetail).
The CommitRetaining does not cancel or influence the current Insert of
the editable record.
So you can edit or insert a new record in one dialog window, switch to
another window, add or edit existing records, post them and do
CommitRetaining. Then switch to the primary window and you’ll
be able to use the new code. So it is not necessary to have a separate
transaction for each table, the read and write transactions are ok.