Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Returning the field name associated with tag
Message
 
 
To
30/01/2002 16:59:48
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00613089
Message ID:
00613134
Views:
11
No, but you can use fcount() and field() in a FOR loop to figure out what fieldnames are in the KEY().
lparameter tcExpression
local lcFields
for lnI = 1 to fcount()
    if at(field(lnI), upper(tcExpression))
       if not empty(lcFields)
          lcFields = lcFields + ','
       endif
       lcFields = lcFields + field(lnI)
    endif
endfor
return lcFields
>How can I get the field name associated with an index tag.
>
>For example: the KEY() function returns the index expression, but is there a function to return the field name that the tag belongs to?
>
>If I: INDEX ON UPPER(myfield) TAG mytag, ?KEY('mytable', 1) returns UPPER(myfield). I only want the field myfield returned.
>
>Thanks,
>
>Jerryt
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform