Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SET NEAR ON - why recno() still returns max number?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: SET NEAR ON - why recno() still returns max number?
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01008622
Message ID:
01008632
Views:
15
This message has been marked as the solution to the initial question of the thread.
Hi Nadya,
the code is tested with VFP9
SET NEAR ON
after locate
EOF() = .t.



>I'm sure SET NEAR ON worked correctly in VFP6. Perhaps, where is a bug in version VFP8? Do we have the same behavior in VFP9?
>
>Well, it would help, if I can read documentation. It clearly states, it applies to FIND and SEEK and doesn't mention LOCATE.
>
>>Hi everybody,
>>
>>I have these values in my cursor
>>
>>CodeVal
>>0100
>>0101
>>0110X
>>etc.
>>
>>I do
>>SET NEAR ON
>>LOCATE FOR upper(CodeVal) = "0102"
>>?recno()
>>
>>It returns 581 (I have 580 records in this cursor). Why it's not working and not giving me the third record? I have SET EXACT OFF as well.
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
Previous
Reply
Map
View

Click here to load this message in the networking platform