Thanks Mike, I guess Valentina Studio must include that function automatically because I certainly didn't add it. Thankfully I've been able to implement a work around, not as powerful as regex, but it works.
On Sat, Feb 7, 2015 at 12:38 PM, Mike Bonner <[email protected]> wrote: > You have to create a user function for it to work. REGEXP is there in > sqlite, but all it does is refer to a function you create. > From this page: > > http://stackoverflow.com/questions/5071601/how-do-i-use-regex-in-a-sqlite-query > > is this. If you can figure out how to execute this with revexecutesql > after opening the db, you can then most likely use REGEXP. The error > pretty much confirms this is the case. > > $pdo->sqliteCreateFunction('regexp', > function ($pattern, $data, $delimiter = '~', $modifiers = 'isuS') > { > if (isset($pattern, $data) === true) > { > return (preg_match(sprintf('%1$s%2$s%1$s%3$s', $delimiter, > $pattern, $modifiers), $data) > 0); > } > > return null; > }); > > > On Fri, Feb 6, 2015 at 9:22 PM, Kay C Lan <[email protected]> > wrote: > > > 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? > > _______________________________________________ > > use-livecode mailing list > > [email protected] > > Please visit this url to subscribe, unsubscribe and manage your > > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
