If you "commit retaining" and later "rollback", your transaction will only undo the changes made
since the commit. If you "rollback retaining", your changes since the last commit (or since the
beginning of the transaction if you've never committed) are undone, and your transaction "sees"
what it did when you started it. "retaining" affects your isolation level; you can commit a
transaction and then perform further actions without seeing recently-committed changes from other
transactions, you can rollback a transaction and try again also without seeing recently-committed
changes (as if you hadn't used the transaction at all, and had it just sitting open for a while.)

-Philip

---------- Original Message -----------
From: "Chad Z. Hower aka Kudzu" <chad-jm@...>
To: <firebird-support@yahoogroups.com>
Sent: Wed, 27 Oct 2004 19:18:59 -0400
Subject: [firebird-support] CommitRetaining

> "Call CommitRetaining to permanently store to the database server all
> updates, insertions, and deletions of data associated with the current
> transaction and then retain the transaction context."
>
> What does this mean? What happens on a rollback?
>
> ------------------------ Yahoo! Groups Sponsor --------------------~-->
> $9.95 domain names from Yahoo!. Register anything.
> http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/67folB/TM
> --------------------------------------------------------------------~->
>
> Yahoo! Groups Links
>
>
>

------- End of Original Message -------