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.