SQLYoga and LC 6.6

[Bob Sneidar]

Try using LIKE instead. customer name LIKE “%bob%” will find all Bobs. 

Bob


On Mar 12, 2014, at 07:59 , Chris Sheffield <cmsheffield at 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 <james at 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 at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode