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

>Aloha,
>
>James

this work or fail ?

SELECT DISTINCT Field1 FROM crsTemp INTO CURSOR crsTemp