General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only