>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.