Yep, submitted a QCC report about 18months ago but nothing has happened. SQLite version 3.7.4 is in LC 6.5.1 and in 5.5 so the version hasn't changed. I believe that version is around 4 years old now and there have been many significant improvements since then.
I think I have a stack somewhere that uses FTS and will try to find it and see if it works in 6.5. I do know that the FTS4AUX extension isn't included in SQLite 3.7.4 but that doesn't explain why things worked in 5.5 but not 6.5. For anyone who is interested, you can find out LC's SQLite library version by opening a database then "SELECT sqlite_version()" Pete lcSQL Software <http://www.lcsql.com> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> On Mon, Jan 27, 2014 at 12:12 AM, Thierry Douez <[email protected]> wrote: > Hi James, > > Before investigating too much, I would check the sqlite version which > implements FTS and then compare it to LC sqlite library version... > > I remember Peter asking for an update of this library. > > > 2014-01-27 James Hale <[email protected]>: > > > > Has anyone else had problems with the FTS module of SQLite in the > current LC? > > > > Is anyone else out there using FTS with SQLite and LC 6.5? > > > Regards, > > Thierry > > ------------------------------------------------ > Thierry Douez - http://sunny-tdz.com > Maker of sunnYperl - sunnYmidi - sunnYmage - sunnYpdf > > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
