Yashodhan, when entering data into such a field on a form use the texbox InputMask property set to 9.99 to enforce max value.
>Hi Everybody.
>I have a table, which contains a numeric field as AMOUNT N(4,2). I thought it would allow the maximum value as 9.99. But, it accepts all other values. Following are my observations –
>REPLACE AMOUNT WITH 9.99 – value becomes 9.99
>REPLACE AMOUNT WITH 99.9 – value becomes 99.9
>REPLACE AMOUNT WITH 0 – value becomes 0.00
>REPLACE AMOUNT WITH 999 – value becomes 999
>REPLACE AMOUNT WITH 9999 – value becomes 9999
>REPLACE AMOUNT WITH 99999 - numeric overflow (may be as total lenght is 4)
>
>This behavior I observed in FPD2.6 as well as VFP6. When I am specifying the length as 1 integer and 2 decimals, why it is accepting the other values?
>
>Thanks,
>Yashodhan.
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.