Regular expressions in SQL in LC

Got a LiveCode personal license? Are you a beginner, hobbyist or educator that's new to LiveCode? This forum is the place to go for help getting started. Welcome!

Moderators: Klaus, FourthWorld, heatherlaine, kevinmiller

Post Reply
danielrr
Posts: 106
Joined: Mon Mar 04, 2013 4:03 pm

Regular expressions in SQL in LC

Post by danielrr » Thu Mar 17, 2016 10:40 pm

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

phaworth
Posts: 592
Joined: Thu Jun 11, 2009 9:51 pm

Re: Regular expressions in SQL in LC

Post by phaworth » Fri Mar 18, 2016 8:36 pm

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

Post Reply

Return to “Getting Started with LiveCode - Complete Beginners”