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

2010-06-28 Thread Alexey Pechnikov
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???

2010-05-12 Thread Scott Hess
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 requires code changes to SQLit

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

2010-05-12 Thread Roger Binns
-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 SQLite

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

2010-05-12 Thread Matt Young
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 "not": syntax error >> sqlite> create  table if no

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

2010-05-11 Thread P Kishor
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? How did you reach that c

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

2010-05-11 Thread Black, Michael (IS)
__ From: sqlite-users-boun...@sqlite.org on behalf of Matt Young Sent: Tue 5/11/2010 1:50 PM To: General Discussion of SQLite Database Subject: [sqlite] create virtual table if not exists table_id??? sqlite> create virtual table if not exists words using fts3 (f1 ); Error: near &qu

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

2010-05-11 Thread Matt Young
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? virtual tables don't persist? ___ sqlite-users mailing list sqlite-users@sqlite.or