• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 158
  • Last Modified:

searching table

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
dpms
Asked:
dpms
1 Solution
 
kjtengCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Tackle projects and never again get stuck behind a technical roadblock.
Join Now