--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> > Hi - I´m new to Firebird and I was wondering what happens, if I am
> > trying to update/add/delete multiple tuples in a single

transaction,

> > and the power fails during the process. Will it rollback when the
> > power comes back on? Or will it leave the update/add/delete

tuples in

> > the database?
> > Im hoping for a rollback :), since I otherwise will have to code

my

> > way out of the problem (i´m using .NET, C# and Firebird

v.1.5.0.3744

> > RC4).
> >
> >
>
> If it never reaches the commit stage, then it will be left as a

record

> version which will be cleaned up next time you garbage collect or
> backup/restore. It won't be rolled back just never committed and

thrown

> away. At least that's what I think. The changes you speak of are

never seen

> again.
>
> Alan

ok - but if it reaches the commit stage, and the unlikely scenario
happens, that the power fails during the commitments.
Ex. 5 tuples to be updated, the first 2 gets updated, then the power
fails and the rest never gets updated.
Will the first 2 then be rolled-back on start-up, or will they have
the updated data?

Martin