Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Get field names that in an index key expression
Message
 
À
01/06/2005 15:20:02
Kay Alexander
Pennsylvania Farm Bureau
Pennsylvanie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Divers
Thread ID:
01019098
Message ID:
01019117
Vues:
24
Nope.
You must program this by yourself
FUNCTION GetIndexKeyFields(cOrder, cAlias)
  LOCAL cOldAlias, cKey, aFlds[1], nFlds
  LOCAL nCnt, oEmpty
  oEmpty   = CREATEOBJECT("Empty")
  ADDPROPERTY(oEmpty, "FieldsCount", 0)
  ADDPROPERTY(oEmpty, "FieldsDef[1,4]", "")
  cOldAlias = ALIAS()
  SELECT (cAlias)
  cKey =  KEY(TAGNO(cOrder,cAlias),cAlias)
  nFlds = AFIELDS(aFlds,cAlias)
  FOR nCnt =  1 TO nFlds
      IF UPPER(aFlds[nCnt,1]) $ cKey 
         oEmpty.FieldsCount = oEmpty.FieldsCount + 1
         DIMENSION oEmpty.FieldsDef[oEmpty.FieldsCount, 4]
         oEmpty.FieldsDef[oEmpty.FieldsCount, 1] = aFlds[nCnt,1]
         oEmpty.FieldsDef[oEmpty.FieldsCount, 2] = aFlds[nCnt,2]
         oEmpty.FieldsDef[oEmpty.FieldsCount, 3] = aFlds[nCnt,3]
         oEmpty.FieldsDef[oEmpty.FieldsCount, 4] = aFlds[nCnt,4]
      ENDIF
  ENDFOR
  SELECT (cOldAlias)
RETURN oEmpty
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform