Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Alias not found error
Message
De
03/12/2004 21:24:41
 
 
À
03/12/2004 10:45:42
Steven Dyke
Safran Seats USA
Texas, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
00966725
Message ID:
00966885
Vues:
8
>Why would the following line 2 generate an error that Alias is not found?
>
>Select * From hdtbl Where hdate = _bldates InTo Cursor mydura_holiday
>If reccount("mydura_holiday") > 0 Then
>***
>EndIf

It generates an error because you do not get a cursor (most often, but not always) with such a "simple" select, you get a "filtered result set"! VFP thinks it's doing us a favor in doing so but it really is a CURSE!!!

I don't remember if VFP6SP5 had the "NOFILTER" clause in it. If you don't see it in the help then I believe that adding a .T. after the asterisk (*, .T.) will prevent it and give you a real cursor.

By the way, a cursor will always be created even if no records were qualified UNLESS VFP decides to give you a "filered result set".

good luck
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform