dynamic search


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?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Hi ahll,

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


ahllAuthor Commented:
thanks, I solved it allready.
The problem was that I made Filtered property to false to change the filter and then I opened again.
Now, I just change the filter and it takes no time.

thanks all anyway

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mohammed NasmanSoftware DeveloperCommented:

  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.Sql.Text := 'Select * from Mytable where Name like ''' + Edit1.text + '%''';

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

Learn Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

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


thanks in advance
Mohammed NasmanSoftware DeveloperCommented:
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.

Community Support Moderator
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.