Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Another VFP 'Bug' or 'Feature'?
Message
 
 
To
30/10/1998 10:09:15
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00152763
Message ID:
00152889
Views:
18
>>Using 'Set Near On' and Seek 'something' should position the record pointer to the nearest matching record. Usually works fine Except when the index is in descending order. In this case the record you wind up on is the next record After the closest match. Tested under VFP 5.0, I have not tried with VFP 6.0. If you repeat this test using FPW 2.6 it works correctly (that is if you assume the above behavior is a bug and not a feature).
>>
>>Now coding a workaround :(.
>Michael,
>Pointer should position itself where the record would be if existed. And it's the case in VFP 5 too, either ascending or descending.
>Cetin

Cetin,

Thanks, I figured out what was happening. It was a combination of 'set exact' setting and the use of a compound index expression. The FPW 2.6 had set exact off and the value being seek'ed only contained part of the indexed expression. The VFP version had set exact on thus giving the difference I observed.

Regards,
Mike
Michael McLain
Previous
Reply
Map
View

Click here to load this message in the networking platform