filtered dbgrid
lazarus / 63-Database

----------------------------------------------------------------------
cryptid · 2021-04-01 09:23

filter db grid not work


procedure TForm1.Edit1Change(Sender: TObject);
begin
       SQLQuery1.Filtered:=False;
       SQLQuery1.Filter:='name' + 'LIKE' + QuotedStr(Edit1.Text );
        SQLQuery1.Filtered:=True;
end;

----------------------------------------------------------------------
wp · 2021-04-01 09:49

Without spaces around 'LIKE' the three parts in your filter text,
'name', 'LIKE', condition, will not be separate words.

----------------------------------------------------------------------
Joek · 2021-04-02 15:26

A small example: this works for me with LIKE ...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 procedure
TFOhlaseni.FilterKodChange(Sender: TObject);var sImput:string;begin  
sImput:=FilterKod.Text;    DMOhlaseni.DSIBOhlaseni.Filtered := false; 
  DMOhlaseni.DSIBOhlaseni.Filter := 'KOD_OHLASENI LIKE ' +
QuotedStr(sImput+'%');    DMOhlaseni.DSIBOhlaseni.Filtered :=
true;end;

----------------------------------------------------------------------
flori · 2021-04-07 12:58

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 SQLQuery1.A
ctive:=false;SQLQuery1.SQL.Clear;SQLQuery1.SQL.Append('select * from
log WHERE user LIKE '''+edit1.Text+'%''');SQLQuery1.Active:=true