Subject Re: incremental search ?
Author emb_blaster
--- In firebird-support@yahoogroups.com, Iwan Cahyadi Sugeng <iwan.c.sugeng@...> wrote:
>
> I'm using clientdataset.filter for increamental search.so. first you must
> load the data to clientdataset by connecting to datasetprovider that connect
> to your ibx dataset,then on the edit control onchange event set
> clientdataset.filter := format('NAME like %s',['%' + quotedchar(edit1.text)
> + '%'])
> Where NAME should be changed to your fieldname
> So the increamental search happen only on the client side and done in memory
> so it should be very fast
>

Problem with this approach is if the table is really big... Transfer to local would take some more time (unless you are already doing this way...)