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

[Bob Sneidar]

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 theQueryObject, “conditions”, theConditions
sqlquery_set theQueryObject, “condition bindings”, aBindings
sqlquery_retrieveAsData theQueryObject, theQueryData

You can do something similar with sqlrecord, but it will always return record objects, not text data.

Also, make SURE you run sqlyoga_reloadSchema() if you have made any alterations to your database schema and save the database object you are using (if you are using one).

Bob

On Mar 12, 2014, at 11:16 , Chris Sheffield <cmsheffield at icloud.com<mailto:cmsheffield at icloud.com>> wrote:

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.