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 <p...@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 > <cmsheffi...@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 <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 >> > _______________________________________________ > 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
