Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Restoring SET INDEX
Message
From
02/11/2009 17:06:35
 
 
To
20/10/2009 02:51:47
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:
01432801
Views:
41
>>>>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!
>
>
>Just remember that for every SET command there is a parameter to SET() function where you can get current value :-)
Thanks!
Previous
Reply
Map
View

Click here to load this message in the networking platform