Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Compound Index Tags (.cdx) 1

Status
Not open for further replies.

ejhemler

Programmer
Aug 30, 2002
68
US
I'm trying to create compound index tag with code instead of the interactive way. so far the code i'm using is as this.

use table
index on field_1 tag uid

the problem is "uid" is a variable that i have set as a user's id. so i want the .cdx to be named what is in the variable, not "uid". is there a way to do this? if this is confusing, please ask me to clarify. thank you in advance.
erik
 
Erik,

I presume this code appears somewhere in code so that the tag name is the id of the user using the system at that time?

I think if you put &uid then it would work out what was in uid and use that as the tag.

Stewart
 
I found this in my Foxpro v 6.0 You mentioned using a varible.

Note DO NOT USE A VARIABLE, an array element, or a field or field expression from a table in another work area for eExpression. If you access an index that contains a variable or field that no longer exists or cannot be located, Visual FoxPro generates an error message. Memo fields cannot be used alone in index file expressions; they must be combined with other character expressions.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top