Re: [sqlite] Help with an SQL statement

2011-12-04 Thread Adolfo Jiménez Millán
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

[sqlite] Help with an SQL statement

2011-12-01 Thread Adolfo Jiménez Millán
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