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 rog...@rogerbinns.com 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 Matt Young
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

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 Scott Hess
On Wed, May 12, 2010 at 10:40 AM, Roger Binns rog...@rogerbinns.com 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

[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.org

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

2010-05-11 Thread Black, Michael (IS)
-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 not: syntax error sqlite create

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 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

[sqlite] create virtual table if not exists

2009-10-09 Thread cefbear
Hey there, this has already been requested over two years ago (2007-08-30), but the ticket (#2604) is still pending: http://www.sqlite.org/cvstrac/tktview?tn=2604 The patch by Scott Hess (2008-08-28) looks sane - should be no problem to apply. Without this statement, I have to check