Displaying Limbo Transaction Information
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