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. 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 Sun, Jan 26, 2014 at 6:31 PM, James Hale <[email protected]> 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 > [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
