>>>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
Ah, I thought you had forty fields, and therefore a problem, or didn't even have the whole query in your hands - it may have come from a sql-side view or something, and you wanted to drop a column from that. With just a handful of fields, no big deal.