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

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

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

Message

De

26/04/2005 16:42:56

Naomi Nosonovsky
Wisconsin, États-Unis

À

Tous

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

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

Versions des environnements

Visual FoxPro:

VFP 8 SP1

OS:

Windows XP SP2

Divers

Thread ID:

01008622

Message ID:

01008622

Vues:

65

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