Master-Detail (ORDER and ORD_DETAIL)

ORDER is insert state , details are in a memory table:
==================================

StartTransaction
try
  ORDER.Post;
  // code to Insert the records into the disk based detail table
  COMMIT;
except
  ROLLBACK;
end;

===================================

if the above transaction fails, nothing is inserted into detail table, which is fine. But I lost the current ORDER record, which
was in insert state before the transaction.

What is the best way for getting the ORDER record back into the insert state with the same values again, if the transaction
fails?

Ahmet

Ahmet,

<< if the above transaction fails, nothing is inserted into detail table,
which is fine. But I lost the current ORDER record, which
was in insert state before the transaction.

What is the best way for getting the ORDER record back into the insert
state with the same values again, if the transaction fails? >>

Don't include it in the transaction by using a restricted transaction on
only the detail table:

http://www.elevatesoft.com/dbisam4d5_transactions.htm

--
Tim Young
Elevate Software
www.elevatesoft.com

<<Don't include it in the transaction by using a restricted transaction on
only the detail table:>>


ORDER.Post;
StartTransaction
try
 // code to Insert the records into the disk based detail table
 COMMIT;
except
 ROLLBACK;
end;

In this case, there is another problem if ORDER is posted to the database and transaction failed.

Ahmet

Ahmet

I've been using a solution that was not very easy to implement. I had
inherit a TDBISamDatabase and changed the StartTransaction, Commit and
RollBack method.

Just *after* the transaction starts, it saves (in memory) the current record
of tables in insert or edit mode and the record pointer from tables in
browse mode. If the commit occurs OK then the memory is freed but if it
fails I have a way to get my tables in a situation just before the
transaction. It takes care of Refresh ALL tables before back to this
situation.

IOW, it takes a picture *before* transaction and if it fails then a put the
initial picture back.

I have been using this since 4.15 and works like expected.

Eduardo

Ahmet,

<< In this case, there is another problem if ORDER is posted to the database
and transaction failed. >>

Well, you either have the ORDER table in the transaction or you don't.
There is no in-between.  If you want to preserve the original ORDER record
after a rollback, then you need to save it in a temporary table and then
restore it manually after a rollback.

--
Tim Young
Elevate Software
www.elevatesoft.com