Luc,

You are right! I did a test and know my concept is wrong. The fact is
a statement and any triggers fired is treated as a *single operation*
by the engine, all updates are undone if an exception occurred, there
is no partial updates. Too bad I cannot find this in the IB6 manual.

Many thanks.
Michael

--- In IBObjects@yahoogroups.com, Lucas Franzen <luc@r...> wrote:
>
> Michael,
>
>
> >
> > Luc,
> >
> > How about the user corrects some entry and post again? Without the
> > rollback, I thought the previous partial updates will be saved
> > together with this successful post.
>
> No, the fail was caused by triggers for a record on a table that
> couldn't be posted.
>
> But if you have two (or more) different queries on doifferent tables
> (for example one posting a record to a customer table and another
record
> to an adress table) and the error occurs in posting the second table
> then you shouldn't commit since then the first record would be
stored.
>
> Luc.