Page 1 of 1

Regular expressions in SQL in LC

Posted: Thu Mar 17, 2016 10:40 pm
by danielrr
Hi all,

I think in order to be able to make queries on a SQLite database using regular expressions you need a function called regexp; and in order to use this function you need to compile a dynamic library extension.

I could be wrong in every respect, of course, but if not, How can you compile such a dynamic library extension to a SQLite database in Livecode?

best,

Daniel

Re: Regular expressions in SQL in LC

Posted: Fri Mar 18, 2016 8:36 pm
by phaworth
Can't help on the compile part of the question but you can use the SQLite load_extension function to dynamically load extension libraries.
Pete