VFP bug? this is very strange

[papadopo]

Hello everybody,

I use VFP 7

I have a table MyTable.DBF with a field MyField N(15,4) with values

23334.9000
23334.9000
23334.9000

I go:

SELECT MyTable
CALCULATE STD(MyField) TO X

VFP gives as result x = *******************

instead of 0

the really weird thing is that when i change the values to

23334.9100
23334.9100
23334.9100

I get the correct result

Another thing is that if i go

SET DECIMALS TO 2

the STD works fine with these specific values ( 23334.9000
)

Have you heard of anything about this sort of thing? Is this a bug?

----------
"Never Send a Human to do a Machine's Job"

 

[kenndot]

i tried it in 6 & 8 and i got 0 in both... i don't have 7 or i'd try that too

are you doing this in the command window and then displaying "x"? or are you putting this into a table with perhaps not the correct field size? that could give you those results, too

 

[rgbean]

More curious, I ran the following code in VFP 5.0a SP3, VFP 6.0 SP5, VFP 7.0 SP1, VFP 8.0 SP1 and VFP 9.0 beta (build 1720).

set talk on
set decimals to 2
CREATE cursor MyTable (MyField N(15,4))
INSERT INTO Mytable VALUES (23334.9000)
INSERT INTO Mytable VALUES (23334.9000)
INSERT INTO Mytable VALUES (23334.9000)

SELECT MyTable
CALCULATE STD(MyField) TO X
?x

It worked "right" in all but 5.0.

If I changed the 2nd line to:
set decimals to 4
It "failed" in all of them.

Rick

 

[papadopo]

kenndot: yes, im doing this in the command window.

How come this fails with

set decimals to 4

for this specific values. for other values it works just fine

----------
"Never Send a Human to do a Machine's Job"

 

[baltman]

quick fix:

CALCULATE STD(MyField+.0001) TO X