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.