[RBG7-L] - Re: Specifying a value range

[A. Razzak Memon]

Charlie,

Change BETWEEN '1' AND ... to BETWEEN 1 AND ...

Notice the digit 1 without single quotes.

Single quotes around the digit makes it TEXT.

Hope that helps!

Very Best R:egards,

Razzak.

At 12:27 PM 7/16/2004 -0500, Charlie Parks wrote:

Is there a way to specify a rule that verifies a column value range is between 1 and a value in a different column?

I tried this:

RULES 'Value for AnswerInteger cannot be outside allowed range.' +
               FOR `ttAnswers` SUCCEEDS  +
               WHERE AnswerInteger BETWEEN '1' AND answerinteger <= ans+
werinteger in (select QuestionScale from Questions+
 where questionrecno = questionrecno)

but it allows values that exist outside of the range.