Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to open google like dropdown on search
Message
From
04/10/2017 07:11:26
 
 
To
03/10/2017 17:26:45
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01654753
Message ID:
01654763
Views:
75
use simply an autocomp textbox with autocomplete=1
this fills a vfp autocomp table located in home(7)+"autocomp.dbf" and retrieves the data field relative to the source (text1) alphabetically...

see foxhelp in "AutoComplete Property" with these values:
0 Does not display a list of entries.(default)
1 Alphabetical Sorts entries alphabetically and is not case sensitive.
2 Most Frequently Used (MFU) Sorts entries based on the highest count.
3 Most Recently Used Sorts entries based on the Updated field in the source table with the most recent first.
4 Custom Uses the Weight field populated using your own algorithm to specify how you want the entries sorted. The results are sorted in descending order (highest to lowest value). If there are ties, then the Updated field is used (most recent appears first).

Note: can zap the autocomp.dbf table for non requested values in home(7)+"autocomp.dbf
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform