>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.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up