>You guys have been very helpfull in the past. Thank you ahead of time for any responses.
>
>I am trying to add a column to a cursor created by the Afields command but I am getting the error message on the alter statement: Field name is a duplicate or invalid.
>
>Select invoiceitems
>ordnumfields = Afields(orditemfieldarray)
>Create Cursor orditemview From Array orditemfieldarray
>alter table orditemview add column toplevelitem c(20)
>
>-Randy
You can not alter the cursor's structure once it has been created. The easiest solution, as already stated here, is to add an item into the "orditemfieldarray"
Select invoiceitems
ordnumfields = AFIELDS(orditemfieldarray)
DIMENSION orditemfieldarray[ordnumfields+1, ALEN(orditemfieldarray, 2)]
orditemfieldarray[ordnumfields+1, 1] = 'toplevelitem'
orditemfieldarray[ordnumfields+1, 2] = 'C'
orditemfieldarray[ordnumfields+1, 3] = '20'
orditemfieldarray[ordnumfields+1, 4] = '0'
orditemfieldarray[ordnumfields+1, 5] = .F.
CREATE CURSOR orditemview FROM ARRAY orditemfieldarray