Do you've crsTemp cursor open AGAIN under different alias?
>
>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
--sb--