>VFP7/SP1 IDE. I have no DBC open.
>
>This works:
>
>Create Cursor aoao (col1 c(40) )
>Alter Table aoao add column coco c(40)
>
>
>This doesn't:
>
>Select * from freetable into cursor iamfree nofilter readwrite
>Alter table iamfree add column coco c(40)
>
>
>What is the best way to alter a cursor's column schema?
>
>Thanks.
Make sure that none of the field names in the freetable exceed a length of 10, otherwise the ALTER TABLE command will generate an error. In the example you posted, would it not be easier to just change your SQL as follows:
SELECT *, SPACE(40) AS coco from freetable into cursor iamfree nofilter readwrite