Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Get field names that in an index key expression
Message
 
To
01/06/2005 15:20:02
Kay Alexander
Pennsylvania Farm Bureau
Pennsylvania, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01019098
Message ID:
01019117
Views:
23
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform