>Documentation says the VFP Integer Range is from -2147483647 to 2147483647, but I'd say it's simply a documentation bug.
No, this is correct.
try this
CREATE CURSOR bb (aa i)
INSERT INTO bb values(0x80000000)
? aa
LOCATE FOR aa=0x80000000
? FOUND()
> So if -2147483648 would also be a VFP integer, not only a C++ integer, the rest of the bug is, that SEEKing values out of the field type range doesn't work.
But id should work!
>
>It's not very satisfactory, but I'd say it would make a seek slower if there is a type conversion needed to compare to larger numbers. So I'd bet it's by design.
The conversion is needed for every number.
>
>Have you tried other seeks, eg seeking a C(11) expression in a c(10) field or seeking numbers out of range of a fixed point Number field?
It work.
CREATE CURSOR bb (aa N(5,2))
INSERT INTO bb values(1)
INDEX on aa TAG ttt
SET NEAR ON
SEEK -1000000000
? aa,FOUND()
>
>Bye, Olaf.