Sounds interesting, I think Skip was interested in using a filter with a datagrid.
I went a bit further with my test by using an FTS3 table and the snippet function to return the data. The nice thing about that approach is that the parameters to the snippet function include the html to use before and after the matched text so I can skip the loop in the original code that hilites the matched text. Using that method, the time to display the results is about twice as fast as the the original code but as before, the difference is not noticeable to the 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 Wed, Dec 24, 2014 at 2:22 PM, Gerry <gerry.or...@gmail.com> wrote: > 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 <p...@lcsql.com> 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 < > > ad...@flexiblelearning.com> 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 > > > use-livecode@lists.runrev.com > > > Please visit this url to subscribe, unsubscribe and manage your > > > subscription preferences: > > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > > > _______________________________________________ > > use-livecode mailing list > > use-livecode@lists.runrev.com > > Please visit this url to subscribe, unsubscribe and manage your > > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
