Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Verify if a field already exists in a table
Message
 
 
À
06/07/2007 12:36:56
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:
01238262
Vues:
21
>>Hi everyone..
>>
>>How can I verify if a field already exists in a table?...
>>Need to create it if doens´t....
>>
>>Thanks in advance
>>Carlos Burgos
>
>Carlos, here you go:
>
>llFoundIt        = .F.
>lnFC            = FCOUNT()
>For I = 1 to lnFC
>  If FIELD( I ) = lcFieldILookFor
>      llFoundIt = .T.
>  EndIf
>EndFor
>
>If not llFoundIt
>  ... Code to create field in table
>EndIf
>
>
>Terry

Why not get out of the loop once you found it? Though it would be using "premature exit" :)
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform