LC, SQLite and REGEXP
Kay C Lan
lan.kc.macmail at gmail.com
Fri Feb 6 23:22:52 EST 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