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