with adoquery1 do begin filtered := false; Filter := format(' year(pxsj) = %s ',[edit1.text]); Filtered := true; end;
table1.filtered:=true; if checkbox1.checked then table1.filter:=format('类别'+'='+'''%S''',[edit1.text]);用一dbgrid控件与table相连,过滤结果将显示在里面table1.filtered:=false;后可以重新进行新的过滤
' and pxsj < ' + inttostr(strtoint(edit.Text) + 1) + '-01-01';
笨办法,应该能用吧
begin
filtered := false;
Filter := format(' year(pxsj) = %s ',[edit1.text]);
Filtered := true;
end;
if checkbox1.checked then
table1.filter:=format('类别'+'='+'''%S''',[edit1.text]);用一dbgrid控件与table相连,过滤结果将显示在里面table1.filtered:=false;后可以重新进行新的过滤