How do I search for values in a DBGrid and use them for an equation?

Question

I recently made a very basic "Client" DBGrid that shows info from an Access database (connected made with an ADOQuery, DataSource,ADOConnection and ADOTable). I would like to know if there is a way that I can search for spesific records (like just a name) and add the "Payment" table of that record together and show it in a Memo when I press a button.

I have searched for help far and wide and I couldn't find anything logical, it may be a stupid question to someone who is an expert but I find this very difficult, so please be kind.

Answer 1

Search should be done via ADOTable methods Locate(). If you use ADOQuery you can rewrite SQL for search as well (don't forget to protect against injections and use parameters if possible) If you need to display some extra info while pressing a button - obtain needed key value from AdoTable and apply as parameter for dependent query

Answer 2

I did not understand your question very well, I ask you to identify your problem and explain precisely to make it easier on us to help you.

-To search for a customer name in the table is as follows :

If Not ADOTable1.Locate('Name',Edit1.Text,[]) then
   MessageDlg('The customer does not exist !',mtInformation,[mbOK],0);

Locate Options : loCaseInsensitive,loPartialKey .

You can also search by ADOQuery Here's an example:

ADOQuery1.Close;
ADOQuery1.SQL.Text := 'Select * From YourTable Where Name ='+QuotedStr(Edit1.Text);
ADOQuery1.Open;

Or you can use ADOQuery Parameters Like this:

ADOQuery1.Close;
ADOQuery1.Parameters.ParamByName('Term').Value:=Edit1.Text;
ADOQuery1.SQL.Text := 'Select * From YourTable Where Name=:Term';
ADOQuery1.Open;

Good Luck.