Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG: SET NEAR and integer seek
Message
From
08/06/2005 12:37:26
 
 
To
08/06/2005 11:43:35
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01021240
Message ID:
01021460
Views:
13
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform