Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to Add a Field with more than 8 chars long
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00846298
Message ID:
00846308
Views:
24
I want to point out that your code works in both cases because field name lenght is limited to 10 characters not 8. It'll generate an error in VFP7 and later if any cursor field name is longer than 10 characters because the field name could be truncated as result of the ALTER TABLE command.

>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.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform