Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using multiple index on a file/cursor?
Message
From
15/08/1999 17:47:39
 
 
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:
00253913
Views:
18
Hi Peter,

>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)
>
>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?

I think this might help you:
SELECT Clients
lcOldOrder=ORDER() && or set('order') to save the current order
SET ORDER TO CLIENTNUM
IF SEEK(This.Value)
  *You found it
ELSE
  *You didn't so display your message box
ENDIF
SET ORDER TO (lcOldOrder) &&Restore your order
To be honest, I'm not sure if what your doing is a good method. If the user tabs to the TextBox and doesn't know any order number, there is no way to leave and the user is trapped. You should put your code in somplace other than the valid ( a search button or lostfocus, so the user can leave or return at will) or maybe another combobox with incremental search enabled?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform