--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 11:03 AM 5/04/2004 +0000, you wrote:
> >Hi Everyone.
> >
> >What would happen if there is something like a power failure while
> >ib is busy committing data?
> >
> >I experienced a problem a few days ago: A Delphi procedure

executed

> >a single stored procedure (this sp calls more stored procedures

etc.)

> >
> >Some error had to happen because the process was not completed.
> >*Some* of the data was commited, though. Is it maybe possible that
> >the Exception class in Delphi didn't catch an SQL error, or
> >something?
>
> It would make no difference. If an exception happened, the

application

> would have to fix the error for a subsequent commit to succeed.

If there

> was a power failure, anything that was executed but not committed

would

> have been left in that state for a while...but eventually it would

have

> been just garbage collected.
>
> The important thing is that nothing gets "half-committed".
>
> It could NOT happen that a chain of embedded SPs got interrupted

and left

> some work committed. There is just no mechanism for this to

happen. It

> didn't happen. If work was committed from that operation, then

all of the

> work in that transaction was committed.
>
> /heLen

Thanx Helen.