Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alias not found error
Message
From
03/12/2004 21:24:41
 
 
To
03/12/2004 10:45:42
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00966725
Message ID:
00966885
Views:
7
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform