Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Verify if a field already exists in a table
Message
De
06/07/2007 12:36:56
 
 
À
06/07/2007 12:27: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:
01238255
Vues:
19
>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
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform