Forum > Database
filtered dbgrid
(1/1)
cryptid:
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:
Without spaces around 'LIKE' the three parts in your filter text, 'name', 'LIKE', condition, will not be separate words.
Joek:
A small example: this works for me with LIKE ...
--- Code: Pascal [+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i < x.length; i++) { x[i].style.maxHeight='none'; x[i].style.height = Math.min(x[i].clientHeight+15,306)+'px'; x[i].style.resize = "vertical";}};} ---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:
--- Code: Pascal [+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i < x.length; i++) { x[i].style.maxHeight='none'; x[i].style.height = Math.min(x[i].clientHeight+15,306)+'px'; x[i].style.resize = "vertical";}};} ---SQLQuery1.Active:=false;SQLQuery1.SQL.Clear;SQLQuery1.SQL.Append('select * from log WHERE user LIKE '''+edit1.Text+'%''');SQLQuery1.Active:=true
Navigation
[0] Message Index