On 26/08/10 17:38, Simon Slavin wrote: > So someone can check it out. Try it with a VIEW that definitely doesn't > exist, or use > > CREATE VIEW IF NOT EXISTS ... >
As far as I can work it out, the statement then prepares OK - but seems then to execute as a no op. Since having completed that script and then checking the schema with the command line sqlite3 utility, the view no longer exists. This seems completely wrong. Surely it should do this check at *execute* time not at *prepare* time. -- Alan Chandler http://www.chandlerfamily.org.uk _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
