I believe you can ALTER TABLE of a
CREATE CURSOR ...
not a
SELECT ... INTO CURSOR ..., even READWRITE
>Bonjour Thierry,
>
>Not sure if it's what you wanted but just an ordinary cursor.
>
>Select Field1, field2 from WhateverTable into cursor cResultingCursor readwrite
>
>>How is the cursor created?
>>
>>>I created a cursor. I did some additional processing after that cursor was created. Now there's a column I don't need anymore.
>>>
>>>How do I get rid of that column?
>>>
>>> I tried the following
>>>
>>>ALTER table NameOfCursor drop column NameOfColumn
>>>
>>>Didn't work.
>>>Error 1115 : Invalid operation for the cursor.
>>>
>>>Is the only solution creating another cursor and selecting only the needed columns from the original cursor?
Thierry Nivelet
FoxinCloud
Give your VFP application a second life, web-based, in YOUR cloud
http://foxincloud.com/Never explain, never complain (Queen Elizabeth II)