Thanks. A novice sometimes posts prior to a complete search of documentation.
On 5/11/10, P Kishor <punk.k...@gmail.com> wrote: > On Tue, May 11, 2010 at 1:50 PM, Matt Young <youngsan...@gmail.com> wrote: >> sqlite> create virtual table if not exists words using fts3 (f1 ); >> Error: near "not": syntax error >> sqlite> create table if not exists U (w1 ); >> sqlite> >> >> Different syntax? > > Yes. > >> virtual tables don't persist? > > How did you reach that conclusion? Did you create a virtual table > successfully, quit sqlite, then reopen the db and found the virtual > table missing? > > > > -- > Puneet Kishor http://www.punkish.org > Carbon Model http://carbonmodel.org > Charter Member, Open Source Geospatial Foundation http://www.osgeo.org > Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor > Nelson Institute, UW-Madison http://www.nelson.wisc.edu > ----------------------------------------------------------------------- > Assertions are politics; backing up assertions with evidence is science > ======================================================================= > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users