SQLite and FTS in LC 6,5x

[Peter Haworth]

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 <th.douez at gmail.com> 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 <james at thehales.id.au>:
> >
> > 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
> 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
>