Validate numeric form field entry

technopak · Post by **technopak** » Tue May 05, 2009 7:06 am

Thanks support,

As you say, the system will validate the input correctly, but the problem is as I mentioned in my original post - all data entered in the form is lost and the user must start all over again. As you'll understand, this is a big headache if there are many fields to be completed on the form.

If it's a limitation, that's fine.

Can someone tell me why the validation rule which I tried originally fails -

If NOT (Object.Deposit BETWEEN 1 AND 1000000) THEN
REPORT ERROR 'Value of Deposit is invalid'

Does alpha input qualify as being between 1 AND 1000000 ?

Perhaps the system validation of the #.00 format field occurs before the rule of the object ??

Peter

aware_support · Post by **aware_support** » Tue May 05, 2009 10:13 am

What does the LogViewer say?