Video of my project (turn the sound off unless you like dogs barking): http://quick.as/erqospn9
I just do: "SELECT * FROM companytable where company_name like " && "'%"&searchText&"%' order by company_name" ...then get the result in an array and pop it into the datagrid, updating as the user types. It's fast enough on a 1000 record database - that's about as big as the database would ever get on that project. Gerry On Thu Dec 25 2014 at 10:54:04 AM Peter Haworth <p...@lcsql.com> wrote: > 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 > _______________________________________________ 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
