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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top