Multi field Filter
lazarus / 61-Beginners

----------------------------------------------------------------------
Petrus Vorster · 2025-07-23 12:22

Greetings All.

Still on normal DBF files.
I have a Filter on a TDBF attached to a Tdbgrid.

The user will enter text in a Tedit e.g. a surname, portion of an
address and so forth.
This filter does work:
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i Filter :=
Format('Surname="%s" or Address="%s"',[Edit14.Text,
edit14.Text]);dm1.BOXES.Filter:=filter;dm1.boxes.Filtered:=true;
It will check for the match in either field Surname or field Address.
The match need to be perfect or else it will not work.

Right when I started, someone here showed me how to filter on SIMILAR
data e.g. a portion of the supplied text. I just cannot find that
example anywhere.

If someone would please be so kind, then I can finally finish this
little project.

Regards, Peter

----------------------------------------------------------------------
Petrus Vorster · 2025-07-23 12:40

Nevermind. I found it.

you only need to put an * bot sides of the search string.

Thank you all.

-Peter