Digits on right of Decimal points

M

Mohammad Yar

I have designed a table. The numeric fields are defined as:
fILED TYPE :NUMBER;
FIELD SIZE : LONG INTEGER;
DECIMAL PLACES:2

The problem, I am facing is,"The data entered in this field is rounded
automatically.
For example a value '12.10' is rounded as '12' and a value 12.51' is rounded
as '13'".
How can I overcome this problem.
 
D

Douglas J. Steele

Long Integers cannot store decimal places: they're integers.

Change the Field Size to something that can accomodate decimals, like Single
or Double.
 
Top