Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
An intellisense-type data entry feature for form field i
Message
From
30/06/2013 22:15:42
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01577532
Message ID:
01577535
Views:
103
>Has anyone developed an intellisense-type data entry feature that displays a popup-list of "candidate" entries to select from as the user types in a name, address, city, state, etc on a VFP form?

I think these guys have something like that: http://www.google.com

Seriously, you can roll your own variation of incremental search. Actually, in your example city and state could be regular incremental search.

One approach for name and address would be to combine incremental search results and substring search; maybe show incremental results near the top and substring results below in a visually separated section.

It's been a while since I coded something like that but ISTR the performance is pretty good on reasonably modern hardware even with substring searches as long as you're working against a local table or cursor.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform