Subject Re: incremental search ?
Author emb_blaster
--- In, Iwan Cahyadi Sugeng <iwan.c.sugeng@...> wrote:
> I'm using clientdataset.filter for increamental 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...)