The ALTER TABLE command does not work if
- a cursor has field names longer than 10 characters.
- new filed name is longer than 10 characters.
You may add a column using SELECT
SELECT *, CAST( 0 AS int) NewIntField ;
FROM mycursor ;
INTO CURSOR mycursor
>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)
>
--sb--