Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Google-like queries in FoxPro apps
Message
 
 
To
23/02/2002 18:18:35
Rick Graves
Advanced Approach Ltd.
Hong Kong, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00624182
Message ID:
00624253
Views:
19
Rick,

As part of the Advanced Wiki Search tool I wrote there is a VFP class that converts search expressions with operators AND, OR, NOT and ( ) into individual queries for each word and then uses SQLs to combine the individual results using the operators to get the final result. The article and code can be found at http://fox.wikis.com/wc.dll?Wiki~WikiAdvancedSearch

>If you want to get fancy, you could support basic and advanced search operators like Google (see http://www.google.com/help/basics.html and http://www.google.com/help/operators.html).
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform