Recent

« previous next »
Pages: [1]

Author Topic: About SQLite Virtual Table and Lazarus  (Read 1472 times)

Rico54

  • New member
  • *
  • Posts: 8
About SQLite Virtual Table and Lazarus
« on: May 07, 2024, 10:38:19 pm »
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.
Logged

Zvoni

  • Hero Member
  • *****
  • Posts: 2964
Re: About SQLite Virtual Table and Lazarus
« Reply #1 on: May 08, 2024, 08:53:40 am »
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"
Logged
One System to rule them all, One Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad

Rico54

  • New member
  • *
  • Posts: 8
Re: About SQLite Virtual Table and Lazarus
« Reply #2 on: May 08, 2024, 02:09:33 pm »
Thanks Zvoni,

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

marcov

  • Administrator
  • Hero Member
  • *
  • Posts: 12201
  • FPC developer.
Re: About SQLite Virtual Table and Lazarus
« Reply #3 on: May 08, 2024, 04:25:49 pm »
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
Logged

Rico54

  • New member
  • *
  • Posts: 8
Re: About SQLite Virtual Table and Lazarus
« Reply #4 on: May 09, 2024, 09:25:45 am »
Thanks!
Logged
Pages: [1]
« previous next »
 

TinyPortal © 2005-2018