Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADD COLUMN documentation
Message
 
 
To
15/01/2005 14:00:06
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:
00977483
Views:
26
>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.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform