>Quick response - thank you. I still must be missing something though. I changed the column name to be less than 10 characters - even the field itself is a c(10) now and I get a different error message: Invalid operation for the cursor.
>
May be it would be easier for you to just change the original array rather than use ALTER TABLE command. If your cursor already has long names, then you would receive the error you mentioned.
>>>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
>>
>>AFAIK the problem was discussed here and you can not alter cursor to add a field with more than 10 chars.
If it's not broken, fix it until it is.
My Blog