Re: [sqlite] Roll-back

2006-11-28 Thread Benedetta . Turchi
Tools Engineering Tools Website John Stanton <[EMAIL PROTECTED]> 28/11/2006 18:14 Please respond to sqlite-users@sqlite.org To sqlite-users@sqlite.org cc Subject Re: [sqlite] Roll-back That should not stop you from starting a transaction and committing it. Note that Sqlit

Re: [sqlite] Roll-back

2006-11-28 Thread John Stanton
006 17:12 Please respond to sqlite-users@sqlite.org To sqlite-users@sqlite.org cc Subject Re: [sqlite] Roll-back Issue ROLLBACK instead of COMMIT for your transaction. If you have already issued COMMIT it is too late. [EMAIL PROTECTED] wrote: Hi, how can I 'roll-back' some modific

Re: [sqlite] Roll-back

2006-11-28 Thread Benedetta . Turchi
Turchi Engineering Tools Engineering Tools Website John Stanton <[EMAIL PROTECTED]> 28/11/2006 17:12 Please respond to sqlite-users@sqlite.org To sqlite-users@sqlite.org cc Subject Re: [sqlite] Roll-back Issue ROLLBACK instead of COMMIT for your transaction. If you have a

Re: [sqlite] Roll-back

2006-11-28 Thread John Stanton
Issue ROLLBACK instead of COMMIT for your transaction. If you have already issued COMMIT it is too late. [EMAIL PROTECTED] wrote: Hi, how can I 'roll-back' some modifications done by some previous sql statements with SQLite? Thank you Benedetta Turchi Engineering Tools Engineering Tools

Re: [sqlite] Roll-back

2006-11-28 Thread drh
[EMAIL PROTECTED] wrote: > Hi, > > how can I 'roll-back' some modifications done by some previous sql > statements with SQLite? > The ROLLBACK command will undo everything from within a transaction, assuming you have not already committed the transaction. Once a transaction commits, there is