Search for content in more than one column (Ttable)

Asked

Viewed 10 times

1

I am developing an application in Delphi 6, that I need to perform a search in more than one field in a Ttable, using only a search field.

Currently, the search is being done only in a field looking in only one column:

procedure TfrmCadastroChamados.btnPesquisarClick(Sender: TObject);
begin
    tblChamados.Open;
    tblChamados.IndexFieldNames:= ('IdChamado');
    tblChamados.findkey([mskPesquisar.Text]);
end;

But I need to find what was typed in "mskPsearch" not only in Idcalled but also in the other columns of the table, ie, a robust search looking through all fields, and if found, return the result in my Dbgrid.

Someone can help me?

Note: I’m using Ttable in Paradox.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.