how to commit one command in a transaction ?

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 - 09:44:47 CEST