SQLite Forum

'SQL logic error no such module: fts5'
Login
Hierarchical

'SQL logic error no such module: fts5'

(1) By zrzr23 on 2020-10-14 16:57:21 [source]

I am using C#, System.Data.SQLite, version 1.0.113.0

when I use the following code to create virtual table for full text search,

CREATE VIRTUAL TABLE vCustomer USING fts5(....)

I got the error "'SQL logic error no such module: fts5'"

How do I enable it in C#?

Thanks!

(2) By Luca (jedioetzi) on 2022-05-26 14:46:34 in reply to 1 [link] [source]

try the following:

... connection.Open();

connection.EnableExtensions(true); connection.LoadExtension("SQLite.Interop.dll", "sqlite3_fts5_init");