09-06-2008 9:10 AM
Hello,
I have an select options for field perid whose type is Char with length 7.
so my inputs are like AUG'08 , JUL'08 ,JAN'08 .....for perid.
my problem is perid-low if i am taking JUL'08 and
perid-high taking as AUG'08..
so here as perid is of type char, it is taking the ascii value of J and A and throwing message as Lower limit cannot be greater than Higher Limit... how can i avoid this ....
if i am taking lowerlimit as AUG'08 and upper limit as JUL'08 then it is working fine......
Please helpfull answers will be highly appreciated..
09-06-2008 9:21 AM
TO avoid this problem , you may have to work with two parameters side by side and behave them like a Select option.
this case you can overcome the error.
09-06-2008 9:22 AM
Hi,
Can you please send your code for this, so that analysing the issue becomes more clear
09-06-2008 9:26 AM
Declare the SELECT-OPTION field Period as the field type which you will compare in the database table.