Re: how to commit one command in a transaction ?

The basics of a transaktion is to do all (commit) or nothing (rollback). or do a commit after the logging or try an other method of logging e.g. writing to a flat ascii file or screen.

Eric Bole-Feysot heeft geschreven in bericht <353eefc0.1215455071_at_seaquest>...
>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 - 19:59:46 CEST