Thomas Chust <[EMAIL PROTECTED]> wrote: > > On a sidenote, please keep in mind, that all prepared statement handles > become invalid as soon as the database schema changes -- this can > especially be a pitfall when working with the DROP TABLE IF EXISTS and > CREATE TABLE IF NOT EXISTS syntax, because these statements may compile to > NULL statements that *cannot* be magically invalidated when the database > schema changes.
SQLite has been fixed so that IF EXISTS and IF NOT EXISTS always generate a non-NULL statement if there are no errors. http://www.sqlite.org/cvstrac/chngview?cn=3106 -- D. Richard Hipp <[EMAIL PROTECTED]>
