Solved

Filter using two text fields?

Posted on 1998-09-26

Delphi

1 solution

Medium Priority

132 Views

Last Modified: 2010-04-06

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

Comment

Question by:mykyl

[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

Join The Community

1 Comment

LVL 2

Accepted Solution

by:333

333 earned 100 total points

ID: 13408861998-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.

Featured Post

Question has a verified solution.

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

Displaying progress in the main form from a thread in Delphi

Article by: Geert

A lot of questions regard threads in Delphi. One of the more specific questions is how to show progress of the thread. Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…

Delphi

The best way for TEdit Number validation by type number

Article by: Mahdi78

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…

Delphi

NetCrunch network monitor live walk-through

Video by: AdRem

NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

How to run like The Flash in Adobe After Effects

Video by: John

This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…