>>>>Hi All:
>>>>
>>>>I have the following code:
>>>>
>>>>
>>>>USE e_file
>>>>SET INDEX TO x, y
>>>>? SYS(14, 1)
>>>>? SYS(14, 2)
>>>>? 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!
>
>
>Just remember that for every SET command there is a parameter to SET() function where you can get current value :-)
Thanks!