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.