Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Changing the field width of a table
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00802374
Message ID:
00802382
Vues:
19
ALTER TABLE myTable ALTER column myField C(3)

>Good day everyone,
>I want to change the field size of a table with code but can't figure out how to get the syntax correct. The field width is currently 6 and I want to make it 3 and it's of Character type. I'm using Fox Pro 6 by the way. The help for Alter Table states:
>
>ALTER TABLE TableName1
> ADD | ALTER [COLUMN] FieldName1
> FieldType [(nFieldWidth [, nPrecision])]
>
>So I use the following code to test it and I get a syntax error:
>ALTER TABLE myTable ALTER [16] myField C [(3)]
>
>Please help!
>Thanks!
>Max
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform