>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.
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--