Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Disappearing alias?
Message
From
17/01/2005 23:32:24
 
 
To
17/01/2005 22:28:18
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP1
Miscellaneous
Thread ID:
00977939
Message ID:
00977944
Views:
23
>Any guesses on how an alias can disappear?
>
>I have the following:
>
>      SELECT * FROM components INTO CURSOR MyComponents ;
>         WHERE KitID==lcPartNo
>      llIskit = 0<RECCOUNT("MyComponents")
>
>This is in a loop that is executed a few thousand times. On rare occasions, the second line fails with "alias not found" ... and when this occurs, ALIAS() is empty! That's right, I get a cursor with NO alias.
>
>Any guesses on how to get around this? (No, it's not as easy as doing RECCOUNT() -later on, having done various and sundry other things with other SELECT statements, I need to get back to this alias --)
>
>Thanks

Hi James, The second line looks strange. Is it a typo? llIskit = 0<RECCOUNT("MyComponents")

Also, when you say ALIAS() is empty are you issuing an ALIAS() function call? If so then are you sure you are in the right work area because ALIAS() is work area dependent but can take a parameter?
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform