Filter using two text fields?

I need to be able to filter a table based on information taken from two edit.text boxes. How do I do this?
Cheers
Mike Ross

mykyl

Asked: 1998-09-26

Advertise Here

Delphi

1 Solution

LVL 2

333Commented: 1998-09-26

Hi,
Use TQuery, not TTable.

i.e if Query1 is TQuery, then

procedure Form1.Button1Click(Sender:TObject);
begin
if Query1.Active then Query1.Close;
Query1.Sql.Clear;
Query1.Sql.Add('select * from MyTable where Field1="'+Edit1.Text+'" and Field2="'+Edit2.Text+'"');
Query1.Open;
end;

A.

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.

Expand your skills with this month's free Premium course.

Filter using two text fields?

Join & Write a Comment Already a member? Login.

Featured Post