[Gambas-user] sqlite full text search i.e. virtual tables
adamnt42 at gmail.com
Sat Sep 2 15:17:56 CEST 2023
On 2/9/23 10:20 pm, Benoît Minisini wrote:
> 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
>> 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.
Aaaargh! 3 hours ago it didn't work, now it does.
It was raising an error that the table ("namesrch") did not exist, hence
my post. Now, after dinner and a bit of TV, I came back and just before
closing the project concerned tried it again.
Are you some kind of sorcerer or something 😅
More information about the User