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? --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]