Solved

dynamic search

Posted on 2003-12-05
6
354 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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:Mohammed Nasman
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
[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.

 
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:Mohammed Nasman
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses
Course of the Month9 days, 6 hours left to enroll

617 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