Re: difference between statements

Martin Jenkins <mj-Vfh7fEhEWOlaa/[email protected]> Fri, 30 Mar 2007 10:02:15 +0100

Newsgroups	gmane.comp.python.db.pysqlite.user
Organization	XQP Ltd
Message-ID	<[email protected]>

Dennis Lee Bieber wrote:
> 
> 	So... off-hand, it looks as if DDL statements (table creation, etc.)
> which affects SQLite internal tables are immediately committed. But DML
> statements affecting said created table are not auto-commit (I just
> verified that an exception is raised if trying to select from a
> non-existent table).

No need for "off-hand", it's documented behaviour... ;)

Martin