I have an amount field in the database as (15,2) ie. it would accept 13 figures beforw the decimal point with the precesion of 2.
I have set the maxlength of the text field to 16.
1. No one can type all fifteen figures without the decimal point. Max allowed should be thirteen.
2. No one can type more than two figures after the decimal point. Max allowed should be two.
I require the above two validation as not confirming to above causes my insert or update query to fail.
Thanks in advance