SET NEAR ON - why recno() still returns max number? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

SET NEAR ON - why recno() still returns max number?

Message

From

26/04/2005 16:42:56

Naomi Nosonovsky
Wisconsin, United States

To

All

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

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:

01008622

Views:

66

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

Click here to load this message in the networking platform