[Gambas-user] sqlite full text search i.e. virtual tables
benoit.minisini at gambas-basic.org
Sat Sep 2 14:50:49 CEST 2023
Le 02/09/2023 à 08:16, BB a écrit :
> Do we support queries on sqlite virtual tables? I am trying to implement
> a full text search on names in 3 tables. sqlite3 has a full text search
> (FTS) facility that seems to work quite well after limited testing* but
> I can't seem to get access to it via gb.db conn.Find() or conn.Exec().
> The info on sqlite FTS can be found here <https://www.sqlite.org/fts5.html>.
> Any clues?
> * I can add, delete and change the base tables and can successfully
> "update" the FTS "table". Queries executed outside Gambas work fine. The
> search table has two columns, name and type where type is "person",
> "building", "place". A simple query on the FTS would be something like
> "SELECT * FROM namesrch WHERE name MATCH 'Haricot';"
The Exec() method allows you to run any SQL request, so I don't see why
you couldn't use this SQLite extension.
More information about the User