Displaying Limbo Transaction Information
From InterBase
Go Up to Performing Database Maintenance
Use the FetchLimboTransaction method along with the LimboTransactions option to retrieve a record of all current limbo transactions. The following code snippet will display the contents of the TLimboTransactionInfo record, provided that there are any limbo transactions to display.
try
Options := [LimboTransactions];
FetchLimboTransactionInfo;
for I := 0 to LimboTransactionInfoCount - 1 do
begin
with LimboTransactionInfo[i] do
begin
Memo1.Lines.Add('Transaction ID: ' + IntToStr(ID));
Memo1.Lines.Add('Host Site: ' + HostSite);
Memo1.Lines.Add('Remote Site: ' + RemoteSite);
Memo1.Lines.Add('Remote Database Path: ' + RemoteDatabasePath);
//Memo1.Lines.Add('Transaction State: ' + TransactionState);
Memo1.Lines.Add('-----------------------------------');
end;
end;
finally