LiveCode Forums.

Hi, I'm new with Revolution and have been getting around so far without too much trouble, but I have a strange error which I can't figure out. I'm hoping someone on the forum can provide some insight.

answer the number of words in field "memorizeText" where the textColor is "black"

An answer box pops up with the correct number of works, but then I get the error

Handler: can't find handler.

Thanks for any help you can offer. It just seems odd to me that Revolution understands the request, provides the right response, and then gives this error.

As far as I know, "where" is not a supported keyword. (Think SQL.) It's only an illusion that Rev understands; it's simply acting blindly on the first half of the sentence (before where), returning the total number of words in your field, and then continuing on to choke on the where clause, which is unsupported/unknown syntax.

There are various ways of accomplishing your goal, but one of the simplest and speediest would be (instead) to simply keep track of the number of handled (memorized?) words in a separate variable. When you color a word, increment or decrement the variable as needed.

Curry wrote:As far as I know, "where" is not a supported keyword.

True, but after reading that I can see it as a useful extension to the language.

Anyone here submit that to the RQCC?

Thanks for your replies. Now I understand I'll rework this using a variable. I guess the syntax coloring the IDE threw me a bit, but it makes sense considering WHERE is used all the time in SQL.