--- In IBObjects@yahoogroups.com, Lucas Franzen <luc@r...> wrote:

>
>
> No, you don't have to roll it back.
>
> Example:
>
> procedure SaveData;
> begin
> with qry do
> begin
> try
> POST; (1)
> IB_Transaction.Commit; (2)
> except
> end;
> end;
> end;
>
> When you post your query (1) the data is sent to the server, thus

the

> triggers will be executed. Since one of them fails the post will

fail,

> too, thus your query will REMAIN in mode dssInsert or dssEdit and

the

> IB_Transaction.Commit (2) won't be executed, since the post (1) will
> cause the exception.
>

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.

Rgds,
Michael