Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Checking Table Structures
Message
De
02/03/2009 10:27:09
 
 
À
02/03/2009 10:24:39
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01384954
Message ID:
01384956
Vues:
67
>I have these fields that should be in a table. I want to cycle through them and check if they are. If they are not, then I want to add them. What is the best way to do that?
>
>
>			(	status1 L, ;
>				status2 L, ;
>				status3 L, ;
>				status4 L, ;
>				status5 L, ;
>				status6 L, ;
>				status7 L, ;
>				status8 L, ;
>				status9 L, ;
>				status10 L, ;
>				status11 L, ;
>				status12 L, ;
>				status13 L, ;
>				Assigned L, ;
>				AssignedTo V(80), ;
>				AnyKeys L, ;
>				KeyWords M, ;
>				LastTable M, ;
>				LastIssue I )
>
You may use TYPE or VARTYPE to check if field exists, or you may scan through AFIELDS() array; and if field is not there then you use ALTER TABLE to add it.
Edward Pikman
Independent Consultant
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform