asked on

dynamic search

Hi

I need to implement a dynamic search on a table. I need a kind of search that you write in an Edit and the results are filtered below while typing (ie. in a dbgrid). Like in the Windows help.
I tried filtering an IBTable but it's very slow.
Can you suggest me a more efficent way to do this?

thanks.

odissey1

Hi ahll,

In you exmple (withIBTable), replace it with TkbmMemTable (free).
http://www.components4programmers.com/products/kbmmemtable/
It all same as TTable but works much faster. Since you already implemented filter with IBTable this should take no time.

regards,
odissey1

ASKER CERTIFIED SOLUTION

ahll

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mohammed Nasman

Hello

Try using IBQuery with Sql statments, use TQuery is more effeicent than the TTable specially when you useing Client/Server Databases

for example your code will be like this

OnEditChange event
IBQuery1.Close;
IBQuery1.Sql.Text := 'Select * from Mytable where Name like ''' + Edit1.text + '%''';
IBQuery1.Open;

I wrote the code from my head so may it's require some modifiying because I don't use IBX components and Interbase :-)

Regards,
Mohammed

ahll

ASKER

Now that I solved my problem by myself, can I recover my points again?

How?

thanks in advance

Mohammed Nasman

Yes, post a request in CS
https://www.experts-exchange.com/Community_Support/

GhostMod

A request has been made to delete this question. If there are no objections within the next 72 hours, the request will be granted.

EXPERTS: Please leave your thoughts on the request here.

GhostMod
Community Support Moderator