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
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01008622
Message ID:
01008627
Views:
16
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.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform