>>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")
Interesting code Dragan. It's not what I wanted to do but I appreciate the alternative.
I thought about doing the following
Original query would be like
select field1, field2, FieldThatWillBeDropped from MyTable into cursor cTemp
Final query would be like
select field1, field2 from cTemp into cFinalCursor
*******************************************************
Save a tree, eat a beaver.
Denis Chassé