Searching Database using editbox and button

[Venturi]

Hi,

I've done this thing before but i have forgotten how .Here is the problem. On a form I've got DBedit items. they get userinformation from a table. I also have a Editbox and a 'search'-button. I want to enter a number in de Editbox and when I press the button I want it to search the table for the corresponding record. When he finds it he has to display all the user information in the DBeditboxes.

THNX in advange.

 

[EricDraven]

if Table1.Locate('Table FieldName',Edit1.Text,[]) then
begin

{The table will have jumped to the record entered if it has been found}

end;

If using a tables internal record numbers you can use the RecNo command to return the current table record number.

 

[Venturi]

THNX EricDraven!

this is even an easier way than i have done it the last time.

 

[svanels]

My favourite with only an editbox:

procedure edtSearchChange( Sender: TObject);
begin
if (edtSearch.Text <>'') then
try
table1.FindNearest(edtSearch.Text]);
except;
on EDatabaseError do;
on EConverterror do;
end;
end;

This procedure compares all fields, and position the cursor at the closest match. S. van Els
SAvanEls@cq-link.sr