>>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?
>>
>>Aloha,
>>
>>James
>
>If you select fields in the same order as the original table, sometimes VFP creates filtered set. Add NOFILTER to your statement to make sure the real cursor is created.

impossible with a GROUP BY select.