Solved

dynamic search

Posted on 2003-12-05
6
347 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: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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

777 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