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
Regular expressions in SQL in LC
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller
Re: Regular expressions in SQL in LC
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
Pete