>>>>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.
Where do I get it from?

It's not here: http://msdn.microsoft.com/vfoxpro/downloads/updates/default.aspx

Aloha,

James