Solved

dynamic search

Posted on 2003-12-05
6
344 Views
Last Modified: 2010-04-05
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.
0
Comment
Question by:ahll
6 Comments
 
LVL 2

Expert Comment

by:odissey1
ID: 9885135
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

0
 
LVL 3

Accepted Solution

by:
ahll earned 0 total points
ID: 9885830
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
0
 
LVL 22

Expert Comment

by:mnasman
ID: 9885844
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
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 3

Author Comment

by:ahll
ID: 9885870
Now that I solved my problem by myself, can I recover my points again?

How?

thanks in advance
0
 
LVL 22

Expert Comment

by:mnasman
ID: 9885954
0
 
LVL 1

Expert Comment

by:GhostMod
ID: 9899611
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
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now