Hello, On Aug 26, 2008, at 11:34 PM, Dennis Cote wrote:
> Petite Abeille wrote: >> >> Is it possible to use 'if not exists' in conjunction with the >> creation >> DDL for a virtual table? >> > > No, its not possible. > > The syntax of a "create table" statement is shown here > http://www.sqlite.org/lang_createtable.html and that for a "create > virtual table" statement is shown here > http://www.sqlite.org/lang_createvtab.html. The virtual table > statement > does not allow the optional "if not exists" clause. Hmmm... bummer... any reason for such discrepancy? This 'if not exists' clause is rather handy :) Is there a place where one could raise a feature request for such functionality? Thanks in advance. Cheers, -- PA. http://alt.textdrive.com/nanoki/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
