[ANN] Free: Google-style typing filter for LiveCode

[Gerry]

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 <pete at 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.orkin at 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 <pete at 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 <
> > > admin at 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 at 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 at 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 at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>