SQLYoga and LC 6.6

[Chris Sheffield]

Hmm. I still get the same results even after bypassing SQLYoga and using revDataFromQuery instead.

So I’m at a lost. Not sure where the problem is...

On Mar 12, 2014, at 1:26 PM, Peter Haworth <pete at lcsql.com> wrote:

> Hi Chris,
> I created a database with 1 table and added some entries that begin with
> "5-C" then executed your SELECT statement with the same LIKE, ORDER BY, and
> LIMIT clauses using revDataFromQuery in LC 6.6 and it worked fine so
> doesn't seem like it's an SQLite or LC issue.
> 
> Pete
> lcSQL Software <http://www.lcsql.com>
> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
> SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>
> 
> 
> On Wed, Mar 12, 2014 at 8:51 AM, Chris Sheffield <cmsheffield at icloud.com>wrote:
> 
>> More info. I don't think there's an issue with SQLYoga here. I'm worried
>> that I may have come across a bug either in SQLite itself or in LC.
>> 
>> After my query is completely generated, here is my complete query string:
>> 
>> SELECT wordID, targetWord, questionStem, answer, distractor1, distractor2
>> FROM words WHERE words.wordID LIKE '5-C%' ORDER BY random() LIMIT 1
>> 
>> The part that's not working in LC 6.6 is the where clause. Does anyone
>> familiar with sql see any issues with this? As I said before, the same
>> query works just fine with LC 6.5.2 and the older SQLite library. I'm not
>> really sure what to do. I need some of the bug fixes in LC 6.6, but I also
>> need this query to work. Is there a way to take the older SQLite library
>> from 6.5.2 and use that? Should I submit a bug report to RunRev? Not really
>> sure what to do at this point.
>> 
>> Anybody have other suggestions?
>> 
>> Thanks,
>> Chris
>> 
>> On Mar 12, 2014, at 8:59 AM, 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
>> 
>> 
>> _______________________________________________
>> 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