2,497
社区成员
发帖
与我相关
我的任务
分享
procedure Tfrmwh.Edit1Change(Sender: TObject);
var str:string;
begin
str:='';
str:=trim(Edit1.Text);
if str = '' then
dbgrid1.DataSource.DataSet.Filter := ''
else
dbgrid1.DataSource.DataSet.Filter := 'mc like ''%' + str + '%'' ';
dbgrid1.DataSource.DataSet.Filtered := True;
end;
Project aousr.exe raised exception class EDatabaseError with message 'ClientDataSet1: Field 'N' not found'. Process stopped. Use Step or Run to continue.
S:=Trim(Combobox3.Text);
DateTimetoString(sDate1,'yyyy-MM',DateTimePicker2.Date);
DateTimetoString(sDate2,'yyyy-MM',DateTimePicker3.Date);
SQL:='select 年月,部门,床号,姓名,护理等级,托管费,护理费,伙食费,其它费,合计,'+
'发票代码,发票号码,老人编号,身份证号,备注,ID from 老人收费统计 '+
'where (姓名 LIKE '+#39+'%'+S+'%'+#39+') and (年月>='+#39+sDate1+#39+
') and (年月<='+#39+sDate2+#39+') order by ''姓名'',''年月''';
DataModule1.ClientDataSet1.Active:=False;
DataModule1.ClientDataSet1.DataRequest(SQL);
DataModule1.ClientDataSet1.Active:=True;
DBGridEh_AutoSize(DBGridEh1,DataSource1); // 用于DBGridEh数据集的连接和字段的设置
(姓名 LIKE '+#39+'%'+S+'%'+#39+')
就是:DataSet.Filter := 'mc like ''%' + str + '%'' 的效果。;