Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to Add a Field with more than 8 chars long
Message
De
04/11/2003 22:24:29
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00846298
Message ID:
00846308
Vues:
26
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform