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

try on VFP9SP1b1,
i have found a bug where VFP can build duplicate Alias name.
it has perhaps been fixed.