Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADD COLUMN documentation
Message
From
15/01/2005 14:46:01
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro Product Documentation
Environment versions
Visual FoxPro:
VFP 6
Miscellaneous
Thread ID:
00977482
Message ID:
00977489
Views:
43
>>I had never noticed this, but after a question in the dfpug forums, I checked the help for ALTER TABLE, and found the following defficiency:
>>
>>There seems to be no indication whatsoever that the clauses ADD COLUMN, ALTER COLUMN or DROP COLUMN may be repeated more than once.
>
>
>Unfortunatelly, it still the case in VFP9 help. Neither sytax definition, nor following description mention that. However all the way down Example 7 shows how to alter 2 columns in one command.
>
>
* Example 7
>CLEAR
>ALTER TABLE Customer ADD COLUMN Fax2 c(20) NOT NULL
>DISPLAY STRUCTURE
>ALTER TABLE Customer;
>   ALTER COLUMN Fax2 NULL;
>   ALTER COLUMN Fax2 SET DEFAULT .NULL.
>ALTER TABLE Customer DROP COLUMN Fax2
>
I think you should forward your comments to MS.

OK. What is the usual procedure to do that (inform MS)? Sorry to ask, but I hadn't paid much attention to this before.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform