Thanks Hugh, very nice. I couldn't resist trying this using an SQLite database instead of the preloaded data. I created a database with one table named Places with one column named Data that holds the preloaded data, then imported the preloaded data into it.
The script changes were pretty minimal, just open the database at startup, then instead of the filter command: put revDataFromQuery(,,gDBID,"SELECT Data FROM Places WHERE Data LIKE :1 ORDER BY Data","tSearch") tSearch is the variable that holds the search string with "%" signs either after or before/after depending on the wildcard setting. The query takes an average of around 15 msecs vs the filter command taking perhaps 2msecs but neither time is noticeable to a user. Pete lcSQL Software <http://www.lcsql.com> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> On Tue, Dec 23, 2014 at 5:36 AM, FlexibleLearning.com < [email protected]> wrote: > Over the years, people keep asking about how to implement 'display as you > type' widget thang. > > So as a Christmas gift to you all, TypingFilter for LiveCode is fast, > flexible and FREE. The download with example implementation and screenshots > are available here... > > www.FlexibleLearning.com/typingfilter > > > Enjoy! > > > Hugh Senior > FLCo > > > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
