LC, SQLite and REGEXP

Kay C Lan lan.kc.macmail at gmail.com
Sat Feb 7 05:22:52 CET 2015


OK, SQLite DB in Valentina Studio I test the following:

SELECT something FROM aTable WHERE anotherThing REGEX '[acdehkiouBW]{4,6}
Test'

works fine, I get the data I'm looking for. Same SQLite DB accessed via LC,
selecting and updating all sorts of tables and columns, no problem until I
run the above statement. The result is:

revdberr,Database Error: no such function: REGEXP

Any clues?


More information about the use-livecode mailing list