I wrote an sql based version of this for an abandoned iPad app - it displays the results in a datagrid from where they can be edited or deleted. If I find time in the next little while I'll package it up as a demo.
Gerry On Thu, 25 Dec 2014 at 8:47 am, Peter Haworth <[email protected]> wrote: > 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 > _______________________________________________ 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
