SQLYoga and LC 6.6

[Bob Sneidar]

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 <cmsheffield at icloud.com<mailto:cmsheffield at icloud.com>> wrote:

SELECT wordID, targetWord, questionStem, answer, distractor1, distractor2 FROM words WHERE words.wordID LIKE '5-C%' ORDER BY random() LIMIT 1