At 05:49 PM 7/07/2004 +1000, you wrote:

>Can you actually do this in Firebird ?
>
>TRANSACTION PARENT BEGIN:
> TRANSACTION CHILD BEGIN:
> UPDATE 1...
> UPDATE 2...
> UPDATE 3...
> TRANSACTION CHILD COMMIT
>TRANSACTION PARENT ROLLBACK
>
>resulting in undoing the child commit?

No - and yes. To nest one transaction within another, use savepoints
within a single transaction. Details for use are in the Firebird 1.5
release notes.

/heLen