Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using multiple index on a file/cursor?
Message
 
To
15/08/1999 17:26:02
Peter Brama
West Pointe Enterprises
Detroit, Michigan, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00253911
Message ID:
00253981
Views:
15
>I also tried to use the index for the CLIENT number and a SEEK() but when I tried to add a SET INDEX TO CLIENTNUM I got an error about table/cursor buffering which through me. (I still need to work on the buffering stuff for this app... right now everything is set for the defaults)

PMFJI, but a commment here: you need to set buffering off if indexing at runtime, then back on again after you index, that's the error you're gettting.

>Is there a way to have more than one INDEX available at a time on a form? Would I add multiple instances of the file in the DE and set the ORDER property differently or something similar?

Yes, it's better to make the indexes at design time. In addition to what Mike said, it's easier to use SEEK():

IF !SEEK(value,'table','tag')
* for example

then you don't need to set and reset the order.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Reply
Map
View

Click here to load this message in the networking platform