>>>>>UPDATE. I found the cause of the problem. When the column name is greater than 10 characters, you cannot change it. Strange though that VFP allows creating a cursor with a column with the name greater than 10 char, but won't allow to change the name.
>>>>>
>>>>>Hi,
>>>>>
>>>>>I want to change a cursor column name. When I do it in the Command window, it works. Here is the code:
>>>>>

>>>>>cCursorName = "MyCursor"
>>>>>cFieldFrom = "FieldName1"
>>>>>cFieldTo = "FieldName2"
>>>>>alter table (cCursorName) rename (cFieldFrom) to (cFieldTo)
>>>>>

>>>>>So the above works without a problem in the Command window.
>>>>>
>>>>>But when I have pretty much the same code in the .PRG of the program, I get error:
>>>>>

>>>>>Error 1115
>>>>>Invalid Operation for the Cursor
>>>>>

>>>>>
>>>>>Could someone explain why? TIA
>>>>
>>>>How did you create the cursor?
>>>
>>>

>>>create cursor mycursor (description c(50))
>>>

>>>
>>>Note that the field name is greater than 10 char. And I could not change the name.
>>
>>This is a bug for me, but why you need to rename the field in CURSOR?
>>Just create the cursor with the field names you want :-)
>
>I am sure that VFP team will fix it in version 10.0 :).
>
>As to why?. I have to populate this cursor from a json I get in Web API. The method I use from West Wind Client Tools requires that the cursor has exactly the same names as the names in the json. And this json has a name "Description". So I have to get it into a cursor with this name and then change it to something less than 10 char. Because I need to save this cursor as a free table to the drive. And when you save a cursor with a field name longer than 10 char, it cuts the name to 10 char (becomes DESCRIPTIO).

SELECT ..., Description AS Desc FROM .. READWRITE