>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?
Which shouldn't be that hard:
afiel(aF,"nameOfCursor")
lnElement=ascan(af, "myfieldname")
lnRow=asubscript(af, lnElement, 1)
adel(af, lnRow)
dimension af(alen(af,1)-1, alen(af,2))
create cursor newname from array af
append from dbf("nameOfCursor")