On 26 Aug 2010, at 8:29pm, Alan Chandler wrote: > 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.
Which makes some kind of sense. So the thing to do seems to be to use DROP VIEW IF EXISTS ... and then either CREATE VIEW ... or CREATE VIEW IF NOT EXISTS ... Both of those should always both prepare and execute. Like you, I am not enough of an expert on the intentions behind SQLite design to tell whether it should be possible to prepare a statement which will currently fail. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
