Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Faster way to search for a word
Message
 
To
10/06/2008 12:56:13
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01322854
Message ID:
01322859
Views:
9
>what's the fastest way to search for a word?
>
>I use:
>
>SET FILTER TO AT(UPPER('HARDDISK'),UPPER(stockname))=1
>BROWSE
>
>but I think it's too slow
>
>thanks for the help
>
>Jerry

How about:
***AT(UPPER('HARDDISK'),UPPER(stockname))=1 
*** That means stockname BEGINS with HARDDISK, isn't?
*** So IF you use VFP9 And have index on that table based on UPPER(stockname)
*** Try:

SELECT * FROM YourTable WHERE UPPER(stockname) LIKE 'HARDDISK%' INTO CURSOR crsTest
BROWSE NORMAL
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform