Problem solved:
a). I was using an old test directory with version 3.5.4 of sqlite3.exe, hence
the errors in the condition (I suppose).
b) Once updated to the 3.7.9 version, and went away the syntax errors, I
mistakenly believed that the sentence did not produce any results because the
dBase f
Hi all:
Assuming a normal table:
CREATE TABLE names (Id INTEGER PRIMARY KEY, Nm INTEGER);
And an FTS4 table:
CREATE VIRTUAL TABLE fts USING fts4 (name, tokenize=simple);
I want populate the FTS4 table from the content of the names table using the
second form of the INSERT statement:
INSERT I
2 matches
Mail list logo