Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ADD COLUMN documentation
Message
 
 
À
15/01/2005 14:00:06
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Visual FoxPro Documentation de produit
Versions des environnements
Visual FoxPro:
VFP 6
Divers
Thread ID:
00977482
Message ID:
00977483
Vues:
27
>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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform