Try using LIKE instead. customer name LIKE “%bob%” will find all Bobs.
Bob On Mar 12, 2014, at 07:59 , Chris Sheffield <cmsheffi...@icloud.com> wrote: > Thanks for the suggestion James. > > I followed your and Trevor’s suggestion to download the latest version and > have gone in and changed the line of code that opens a SQLite db. In my case, > I’m not seeing a connection problem, though, and the problem isn’t fixed > after changing that line of code. I’m getting a connection just fine. And > some queries are working just fine. But in one place I’m seeing an issue > where setting search criteria is not working. Specifically, I’m using a > “begins with” search. If I comment out the code that sets that condition, my > query works. > > I’m kind of stuck. I need to use LC 6.6 because it contains some bug fixes > for issues I was seeing in this app. I’ll dig into the SQLYoga code a bit > more and see what I can find. > > Thanks, > Chris > > On Mar 11, 2014, at 5:29 PM, James Hale <ja...@thehales.id.au> wrote: > >> Chris, >> >> Do as Trevor suggested and download the latest SQLYoga. >> >> It is no longer password protected so you can modify its handlers. I am not >> at my desk right now but if you find the handler that opens the db >> connection you just need to modify the SQLite case (in the switch statement) >> to handle the new syntax for opening a SQLite connection. >> >> I hit the same issue and just changed the single line to the new syntax. >> >> Hopefully Trevor will modify the code to enable the call to optionally >> enable to the extensions. >> As I wanted them I just changed the line to the new syntax with the >> extensions enabled. >> >> James >> _______________________________________________ >> use-livecode mailing list >> use-livecode@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your subscription >> preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
