Re: how to commit one command in a transaction ?

You need to use SAVEPOINTs, which allow you to rollback only to a specific point in the transaction.

Eric Bole-Feysot wrote:
>
> Hi all
>
> I have a problem I can't figure out:
>
> Look at this code :
>
> insert into logs values ('I do that');
> insert...
> update..
> insert..
> insert... (crash)
> rollback;
> insert into logs value(error);
> commit;
>
> So, I have only one record in my logs table :
> error
>
> I would like to have the two records :
> I do that
> error
>
> In fact, I thing it could be possible to commit only the insert into
> logs command without ending transaction, but How
>
> Thanks
>
> - Eric -
>
> *----------------------------------------------------------*
> Bole-Feysot Eric - BOBST SA - Switzerland
>
> ebole_feysot_at_bigfoot.com (remove underscore to reply)
> *----------------------------------------------------------*
Received on Thu Apr 23 1998 - 18:41:11 CEST