Hello there,
I'm doing some experiments with SQLite DB using FTS. Given the code below, I am
getting an error "unhandled exception: no such module: fts3 [DbError]"
Does db_sqlite can handle the SQLite's FTS feature ? If so, pls, how can I do
that ? Thx in advance, Alfred N.
import db_sqlite, math
let theDbFTS = open("mytestFTS.sqlite", nil, nil, nil)
theDbFTS.exec(sql"Drop table if exists mail")
theDbFTS.exec(sql("""
CREATE VIRTUAL TABLE mail USING fts3(
subject VARCHAR(256) NOT NULL,
body TEXT CHECK(length(body)<10240)
)"""))
theDbFTS.exec(sql"BEGIN")
for i in 1..10:
theDb.exec(sql"INSERT INTO mail (subject, body) VALUES (?,?)", $i, "body"
& $i)
theDb.exec(sql"COMMIT")
theDbFTS.close()
**Error: unhandled exception: no such module: fts3 [DbError]**