Starting with VFP7, the ALTER TABLE command will generate error 1115 if there are field names longer than 10 characters in the cursor because those names will be truncated. Unfortunatelly, the error message description was never updated.
>The following line of code emit an error on VFP 7, 8, 9 but not with vfp 6 sp3:
>
>
>Create cursor BaseCursor(longfieldname Integer)
>
>** Create cursor BaseCursor(ShortField Integer)
>
>ALTER TABLE BaseCursor ADD COLUMN NewField C(8)
>Use In BaseCursor
>
>
>Seems that the alter table don't work with long field name in the cursor.
>
>The Error don't explain the real cause:
>Invalid operation for the cursor (Error 1115)
>An attempt was made to use the PACK command on a cursor.
--sb--