Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Moving from FoxPro to Lianja?
Message
From
04/12/2014 07:40:28
 
 
To
04/12/2014 07:26:39
General information
Forum:
Visual FoxPro
Category:
Third party products
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01610047
Message ID:
01611793
Views:
119
Does this mean I have to re-index before every search. There are approx. 500,00 Names and addresses in this file.

In any case I am using the '$' (contained in) feature i.e. SELECT * FROM myfile WHERE 'FRANK' $ UPPER(NAME). I don't think an index will help here.

I need a data selection for 'FRANK' contained anywhere in the field name. Under XP this runs reasonably fast. But under WIN 7/WIN 8 it is considerably slower, and at times, not always but at times in can grind to a halt.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform