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