Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Verify if a field already exists in a table
Message
De
18/06/2009 14:15:53
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01238247
Message ID:
01406950
Vues:
49
>Programmatically? AFAIK, no.
>
>>Is there any other way to change the structure of the existing table?

Yes -- there is another way. I used it years ago:

use the COPY STRUCTURE EXTENDED command to create a table of the fields. Then add/delete fields as appropriate. Then use CREATE FROM command to create a new table from the COPY STRUCTURE EXTENDED table. Now you have to populate the new table from the original table. This is not as elegant as the ALTER TABLE command, but it was an "old" way to modify the structure of tables.

The COPY STRUCTURE EXTENDED command could also be used to test for the existence of a field as well...
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform