Solved

dynamic search

Posted on 2003-12-05
6
351 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
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!

 
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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

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…
Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

756 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