Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Restoring SET INDEX
Message
From
19/10/2009 17:25:59
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01429897
Message ID:
01429954
Views:
51
>>Hi All:
>>
>>I have the following code:
>>
>>
>>USE e_file
>>SET INDEX TO x, y
>>? SYS(14, 1)   &&returns "E_NO"
>>? SYS(14, 2)  &&return "E_NAME"
>>? SYS(14, 3)  &returns ""
>>
>>
>>Is there a function that will return the .IDX file name, not the key field? I need this so that I can close the table, do some manipulation and then reopen as:
>>
>>
>>use
>>
>>....code....
>>
>>use e_file
>>set index to &indexlist
>>
>>
>>And yes, I must use IDX files. It's an old system I'm working on.
>>
>>Thanks,
>>
>>Yossi
>
>
>? SET("Index")
>
>I didn't use SET INDEX from so many years :-)

Thanks! Both SET("Index") and NDX() work. If the only the VFP help would have pointed me in the right direction in the 'See also' list!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform