Solved

searching table

Posted on 1998-05-02
1
153 Views
Last Modified: 2010-04-06
I want to put together a window where the user can see the data from a table in a list box and as they enter a word an edit box, the list refreshes itself to show a subset of the table with what they entered, whether that be a piece of the word or the whole thing.
0
Comment
Question by:dpms
[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
1 Comment
 
LVL 2

Accepted Solution

by:
kjteng earned 50 total points
ID: 1340633
You may use dblookUpList or dbLookUpcombo component to link the lookup display, lookupitem and lookupsource to the table which contains the data.

What do you mean by "to show a subset of the table"? If what
you want is just to search for a particular item, u just have to add an onChange event to the edit component. Something like this:

procedure TForm1.Edit1Change(Sender: TObject);
begin
  table1.findKey([ edit1.text])
end;

Of course an index must be created and in use for the table


0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
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…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

691 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