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