About SQLite Virtual Table and Lazarus
lazarus / 16-Databases

----------------------------------------------------------------------
Rico54 · 2024-05-07 20:38

I need a little help.
I've create a SQLite Virtual Table based on the main table of my
project (for a full text search purposes) and SQL code works fine in
DB Browser for SQLite 3.12
How I can use it and how display the results in a Lazarus app (maybe
in a Grid)?
(I tried to use it as a normal table in Lazarus, but with no results.)

My developing machine is a MacBook Pro M1 with Lazarus 3.2 and SQLite
3.37.

Thanks for your time.

----------------------------------------------------------------------
Zvoni · 2024-05-08 06:53

See here:
https://forum.lazarus.freepascal.org/index.php/topic,66335.0.html

Note: the fix is in trunk/main, not the current release, though no
idea if the fix has been merged into "fixes"

----------------------------------------------------------------------
Rico54 · 2024-05-08 12:09

Thanks Zvoni,

now some mechanisms are clearer to me. I hope for more suggestions...

----------------------------------------------------------------------
marcov · 2024-05-08 14:25

It is not in fixes. (most unmerged DB fixes are listed here, but
beware that is a list from december)

http://www.stack.nl/~marcov/mergelogs32/fcl-db.html

----------------------------------------------------------------------
Rico54 · 2024-05-09 07:25

Thanks!