> SQLite version 3.0.1 > Enter ".help" for instructions > sqlite> .tables > sqlite> begin; > sqlite> create table foo (value1 integer, value2 integer); > sqlite> just an error; > SQL error: near "just": syntax error > sqlite> commit; > sqlite> .tables > foo > sqlite>
> This was using "shell :memory:" but same happens using a file. > Why foo table still exists? Perhaps because you told it to commit the changes after the error occurred. If you didn't want the changes saved in the event of an error, you should cancel the transaction. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
