0

I am trying to use FTS3 in SQLite. The virtual table is created using sqlitebrowser_200_b1_win.

CREATE VIRTUAL TABLE tbl1 USING FTS3 ( col1 TEXT, col2 TEXT);

When I insert some data it says: no such module FTS3

insert into tbl1(col1, col2) values ('c1', 'c2');

Ondrej Janacek
  • 12,486
  • 14
  • 59
  • 93
user3281006
  • 1

1 Answers1

0

That SQLite Database Browser apparently has not been compiled with FTS. Anyway, it's outdated.

Use some up-to-date tool, like the sqlite3 command-line shell, or the SQLite Manager Firefox addon.

CL.
  • 173,858
  • 17
  • 217
  • 259
  • sqlite3 command-line shell is a tool. I am looking to develop a program in c# that can use FTS3 of sqlite. e.g. System.Data.Sqlite is dll that can be used in c# to communicate with SQLite database. This dll does not provide functionality for FTS3. – user3281006 Feb 12 '14 at 16:42