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, Id 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 youll 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.

Preview text: 
Prices in Euro:

235 (1 copy)
1250 (unlimited)

Volume discounts are available...

Navigation



"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
FOR CUSTOMERS
Download full versions and updates in your Personal Area