Brenda Price wrote:
Will,
Since the input can be several alpha characters as well as numeric. The fix is listed below.
CASE NUM(SEL) AND SEL GE 1 AND SEL LE MAX.VAL
Thank you everyone for the responses. However, the programs were fixed before I asked the question. The question was not how to fix the problem but why it occurred. MAX.VAL represents the maximum attributes in a record in some cases, in others the maximum number of multi-values.
I just have a hard time visualizing why 1X is GE than 1 and LE 40 (from the program I tracked the error to). We are assuming it has something to do with Scientific notation.
Or lack of typing? Maybe the runtime sees a nonnumeric value and does a char conversion? 1 = char(49) and variable MAX.VAL of 40 may be converted to char(52) & char(48), which is more than char(49) char(88) aka 1X.
rog ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
