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 ?
Fast, flexible and high-performance component library for Delphi, C++ Builder and Kylix intended for work with InterBase and Firebird using Direct InterBase API.
|
Question:
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).
Answer:
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.
"FIBPlus is a great choice if you're going to work with InterBase and/or Firebird. The components let you easily use all the features of both databases in your applications...FIBPlus will make your InterBase and Firebird development easier than ever before...". Read the full story. >>Bill Todd, president of The Database Group, Inc., a contributing editor to Delphi Informant Magazine, and a member of Team B
