Re: [sqlite] create virtual table if not exists table_id???

Thanks a lot for this link! 2010/5/12 Roger Binns > > > http://www.sqlite.org/cvstrac/tktview?tn=2604 > > To fix it requires code changes to SQLite and the SQLite team haven't > deemed > this necessary (yet). > > -- Best regards, Alexey Pechnikov. http://pechnikov.tel/

Re: [sqlite] create virtual table if not exists table_id???

On Wed, May 12, 2010 at 10:40 AM, Roger Binns wrote: > On 05/11/2010 11:50 AM, Matt Young wrote: >> sqlite> create virtual table if not exists words using fts3  (f1 ); >> Error: near "not": syntax error > >  http://www.sqlite.org/cvstrac/tktview?tn=2604 > > To fix it

Re: [sqlite] create virtual table if not exists table_id???

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 05/11/2010 11:50 AM, Matt Young wrote: > sqlite> create virtual table if not exists words using fts3 (f1 ); > Error: near "not": syntax error http://www.sqlite.org/cvstrac/tktview?tn=2604 To fix it requires code changes to SQLite and the

Re: [sqlite] create virtual table if not exists table_id???

Thanks. A novice sometimes posts prior to a complete search of documentation. On 5/11/10, P Kishor wrote: > On Tue, May 11, 2010 at 1:50 PM, Matt Young wrote: >> sqlite> create virtual table if not exists words using fts3  (f1 ); >> Error: near

Re: [sqlite] create virtual table if not exists table_id???

On Tue, May 11, 2010 at 1:50 PM, Matt Young 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?

Re: [sqlite] create virtual table if not exists table_id???

Syntax says they are different...virtual tables don't have the same flexibility apparently...I suppose you're looking for "why" though? http://www.sqlite.org/lang_createvtab.html Michael D. Black Senior Scientist Northrop Grumman Mission Systems From: