Re: SQLYoga and LC 6.6

Thanks for all the suggestions on this issue. I finally resorted to dumping my data, creating a new db using Valentina Studio, and loading the data back in. Worked like a charm. I’m back in business. The original file was created with an older version of SQLite, so I’m guessing that had somethin

Re: SQLYoga and LC 6.6

On Thu, Mar 13, 2014 at 9:18 AM, Kay C Lan wrote: > In LC, in multi-line msg box, > > put revOpenDatabase("sqlite","/Users/me/my.sqlite",,,) into tDbID > put "SELECT sqlite_version()" into tDbQuery > put revDataFromQuery(,,tDbID,tDbQuery) into msg > Whoops, should have included one more line: r

Re: SQLYoga and LC 6.6

On Thu, Mar 13, 2014 at 2:16 AM, Chris Sheffield wrote: > I do have a a couple admin tools, and the query runs correctly in both of > them. I tried it in Valentina Studio, which I believe is using a fairly > recent version of SQLite, though I can't tell for sure as I can't find a > SQLite version

Re: SQLYoga and LC 6.6 - Found word(s) list error in the Text body - Found word(s) list error in the Text body

add sqlquery_set theQueryObject, “limit”, “1” if you only want the first occurrence. Bob On Mar 12, 2014, at 16:10 , Bob Sneidar wrote: > Okay so the syntax for sqlYoga would be: > > put sqlquery_createObject(“words”), theQueryObject > sqlquery_set theQueryObject, “select clause”, "wordID,

Re: SQLYoga and LC 6.6 - Found word(s) list error in the Text body

Okay so the syntax for sqlYoga would be: put sqlquery_createObject(“words”), theQueryObject sqlquery_set theQueryObject, “select clause”, "wordID, targetWord, questionStem, answer, distractor1, distractor2” put "wordID LIKE :1“ into theConditions put “5-C%” into aBindings [1] sqlquery_set theQuer

Re: SQLYoga and LC 6.6

Never mind I see you are using LIKE. Okay, so try the Firefox SQLite plugin and run the query there. If it works there and not in Livecode, well you have divided and are prepared to conquer? Bob On Mar 12, 2014, at 08:51 , Chris Sheffield mailto:cmsheffi...@icloud.com>> wrote: SELECT wordID,

Re: SQLYoga and LC 6.6

Try using LIKE instead. customer name LIKE “%bob%” will find all Bobs. Bob On Mar 12, 2014, at 07:59 , Chris Sheffield 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 op

Re: SQLYoga and LC 6.6

On Wed, Mar 12, 2014 at 1:42 PM, Chris Sheffield wrote: > 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... > That is strange since it worked OK for me with both revDataFromQuery and revQuery

Re: SQLYoga and LC 6.6

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 wrote: > Hi Chris, > I created a database with 1 table and added some entries that begin with > "5-C"

Re: SQLYoga and LC 6.6

Interesting. Thanks for trying that. Maybe I’ll try bypassing SQLYoga for that query then and see what happens. On Mar 12, 2014, at 1:26 PM, Peter Haworth wrote: > Hi Chris, > I created a database with 1 table and added some entries that begin with > "5-C" then executed your SELECT statement wi

Re: SQLYoga and LC 6.6

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

Re: SQLYoga and LC 6.6

Pete, I don’t get any kind of error message. In fact, the query sort of returns successfully. It just doesn’t return all the results. When running the query I showed earlier, I only get back the value of the wordID field. No other field values are returned. I do have a a couple admin tools, an

Re: SQLYoga and LC 6.6

Hi Chris, I don;t see anything wrong with the WHERE clause. Do you get any sort of error message or is it that the results of the query are not what you expect? Do you have access to an SQLite admin tool that uses an up to date version of the SQLite library? If so, you could try the SELECT direc

Re: SQLYoga and LC 6.6

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 w

Re: SQLYoga and LC 6.6

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’

Re: SQLYoga and LC 6.6

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 th

Re: SQLYoga and LC 6.6

Maybe I'm misunderstanding since I don't have SQLYoga but if calls to the old format revOpenDatase are failing, that's a bug since every stack that opens an sqlite database will fail. If you don't need the ability to load extensions or change the way blobs work, no change should be required. Inci

Re: SQLYoga and LC 6.6

> > Trevor, if you're listening, have you noticed any issues? I would guess > this has something to do with the updated SQLite libraries. > Getting on a plane so I will be brief. I haven't tested in 6.6 yet. You might download latest SQL Yoga library from my site as the source code is now unlocked

SQLYoga and LC 6.6

Anybody out there using SQLYoga with LiveCode 6.6? In particular with a SQLite database? I have a mobile app using this setup and it’s not working. I don’t get any errors from SQLYoga, but I’m not getting proper results from select queries either. Everything works fine in LC 6.5.2, but not with