>I've found an issue in ALTER TABLE command, it doesn't work adding a field with more than 8 chars of long in VFP cursor.
>
>

>CREATE CURSOR Temp (iid int)
>lcField = "cShort"
>**** This Works *******
>ALTER TABLE Temp ADD COLUMN (lcField) int
>lcLongField = "cLongField"
>**** This doesn't work ********
>ALTER TABLE Temp ADD COLUMN (lcLongField) int
>

>
>What can I do? Any work arround?, I've looking for in the Help, but doesn't say anything about this issue.

The thread starting with Tip o' the Day: ALTER TABLE on a Cursor Thread #476591 Message #476591 may be of interest.