>>Hi All,
>>
>>Here's my newest dilema.
>>
>>I want to SELECT a record set from a cursor and assign the result cursor the same name as the source cursor
>>
>>

>>SELECT Field1 FROM crsTemp INTO CURSOR crsTemp GROUP BY Field1
>>

>>
>>In most cases this query executes with no problem and all is well. However, sometimes I get an error message "Alias name is already in use."
>>
>>How is it that sometimes it works fine and other times I get an error message?
>>
>
>When it fail, the result how many records it should have? none ?
>
There should be records in the result.

>>Aloha,
>>
>>James
>
>this work or fail ?
>

>SELECT DISTINCT Field1 FROM crsTemp INTO CURSOR crsTemp
>

I get the same message.