SQLite and FTS in LC 6,5x

Peter Haworth pete at lcsql.com
Mon Jan 27 12:22:21 EST 2014

Hi James,
I found an old stack that uses an sqlite FTS4 table and it seems to work
fine in 6.5, including loading the data into it.

Are you using FTS3 or FTS4?  Shouldn't really matter but might help narrow
down the problem.

lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>

On Sun, Jan 26, 2014 at 6:31 PM, James Hale <james at thehales.id.au> wrote:

> Hi,
> Has anyone else had problems with the FTS module of SQLite in the current
> LC?
> I have a program that uses FTS and once I opened it in 6.5 I started
> getting SQL errors. To try and track this down I regenerated a new version
> and imported my text. Everything seemed to work fine except when I tried to
> use the FTS feature.
> I then had a look at the tables and lo and behold there is nothing in the
> main text table created for FTS. Wondering if it just wasn't visible I then
> checked my database previously created using LC 5.5.
> It was full of text!
> I will investigate further but it seems the populating of the FTS tables
> is broken.
> Is anyone else out there using FTS with SQLite and LC 6.5?
> James
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

More information about the Use-livecode mailing list