Digits on right of Decimal points

[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.

 

[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.