In a table there is a field called concentration.
It is a Number field.
The numbers vary from 0.025 to 200
When I look at the table in a record whose concetration field has a
value of 0.025, I see 0.03.
If I click on it it shows me the 0.025. No problems there.
In my code I have the following:
NuConcentration = TC.Concentration
If I view nuConcetration I see 0.03
More importantly, when the math is done (numbers X numbers) it is as
if it 0.03.
I need the precision.
Any suggestions?
Thanks,
Craig
Craig Futterman

That is because Paradox displays the number in a default format with only
two decimals when you use view.


Are you sure about that?

If you do

view(nuConcetration * 1000)

I think you should se 25.00



Use the format command to display what you need and set the format of the
fields in you forms and report. You can create your custom formats if you
need to.

Anders

Jonathon,

In addition to Anders post, here's my 2 cents.

Make sure you have NuConcentration explicitly defined, as in:
var NuConcentration number endVar

or cast the value as:
NuConcentration = number(TC.Concentration)

HTH,
Jim Moseley

Good point. I always do it myself but it's easy to forget if you have
compiler warnings off.



Anders

Sometimes I like the format command in this situation,
it helps you see precision of numbers.

To help see default behaviors,
consider the following code snippet:


var
nu number
st1,st2 string
endvar

nu = .025

st1 = string(nu)
st2 = format("W.4",nu)

nu.view("number")
st1.view("nu to string,no format")
st2.view("nu with format")


Robert Wiltshire