Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing the field width of a table
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00802374
Message ID:
00802382
Views:
18
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
Previous
Reply
Map
View

Click here to load this message in the networking platform