Subject | firebird and transaction |
---|---|
Author | VOET Emmanuel |
Post date | 2004-09-15T11:00:55Z |
Hello,
I'd like to know if Firebird supports 2 levels of transactions.
To be clear:
I would like to open a main transaction I will be able at any time to commit or rollback. That exists for sure. But I also would like inside that transaction, to open other ones I could commit or rollback as well.
The objective is to implement a single undo function which was not planned before. Another possibility I have been told, but I don't know for Firebird, it to set a serie of milestones you can at anytime in the main transaction rollback to one of these.
Thanks for your support,
Emmanuel Voet
____
This message and any files transmitted with it are legally privileged and intended for the sole use of the individual(s) or entity to whom they are addressed. If you are not the intended recipient, please notify the sender by reply and delete the message and any attachments from your system. Any unauthorised use or disclosure of the content of this message is strictly prohibited and may be unlawful.
Nothing in this e-mail message amounts to a contractual or legal commitment on the part of EUROCONTROL unless it is confirmed by appropriately signed hard copy.
Any views expressed in this message are those of the sender.
I'd like to know if Firebird supports 2 levels of transactions.
To be clear:
I would like to open a main transaction I will be able at any time to commit or rollback. That exists for sure. But I also would like inside that transaction, to open other ones I could commit or rollback as well.
The objective is to implement a single undo function which was not planned before. Another possibility I have been told, but I don't know for Firebird, it to set a serie of milestones you can at anytime in the main transaction rollback to one of these.
Thanks for your support,
Emmanuel Voet
____
This message and any files transmitted with it are legally privileged and intended for the sole use of the individual(s) or entity to whom they are addressed. If you are not the intended recipient, please notify the sender by reply and delete the message and any attachments from your system. Any unauthorised use or disclosure of the content of this message is strictly prohibited and may be unlawful.
Nothing in this e-mail message amounts to a contractual or legal commitment on the part of EUROCONTROL unless it is confirmed by appropriately signed hard copy.
Any views expressed in this message are those of the sender.