Digits on right of Decimal points

  • Thread starter Thread starter Mohammad Yar
  • Start date Start date
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.
 
Long Integers cannot store decimal places: they're integers.

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