> 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?

If you are using Firebird 1.5, then lookup SAVEPOINTs
in the 1.5 Release Notes.


Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com