Tip from Vlad Khorsun:

  1. add TranNum field to the all interesting tables
  2. fill this field in BEFORE INSERT OR UPDATE trigger using CURRENT_TRANSACTION value
  3. create special table like TranMarks(TranNum, TranMark)
  4. create sequence SeqTranMarks
  5. create ON COMMIT database trigger which will insert CURRENT_TRANSACTION and next value of sequence SeqTranMarks into TranMarks table

Now you have marked all records by transaction numbers and order of transaction's commits.

Like this post? Share on: TwitterFacebookEmail

Related Articles


Firebird Community



Gems from Firebird Support list