regular expressions in SQLite
Posted: Fri Mar 18, 2016 12:07 pm
Hi all,
I submitted this very question to the newbies board, but maybe this is the right place to do it. My apologies for the crossposting.
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. Is this right? If it is, How can you compile such a dynamic library extension to a SQLite database in Livecode? And if not, Which is the right way?
best,
Daniel
I submitted this very question to the newbies board, but maybe this is the right place to do it. My apologies for the crossposting.
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. Is this right? If it is, How can you compile such a dynamic library extension to a SQLite database in Livecode? And if not, Which is the right way?
best,
Daniel