什么数据库? Access: adodataset3.Filter:='卡号='+quotedstr(edit1.text)+' and '+'日期<#'+FormatDateTime('yyyy-MM-dd hh:mm:ss',date)+ '# and '+'打印=0';SQLServer: adodataset3.Filter:='卡号='+quotedstr(edit1.text)+' and '+'日期<Convert(DateTime,'+FormatDateTime('yyyy-MM-dd hh:mm:ss',date)+ ') and '+'打印=0';
adodataset3.Filter:='卡号='+quotedstr(edit1.text)+' and '+'日期<Convert(DateTime,'+FormatDateTime('yyyy-MM-dd hh:mm:ss',date)+ ') and '+'打印=0';
应该是OnFilterRecord事件,例: procedure TForm1.AdoDataSet1FilterRecord(DataSet: TDataSet; var Accept: Boolean);begin Accept :=False; if (DataSet.FieldByName('卡号').AsString = edit1.text) and (DataSet.FieldByName('打印').AsString = '0') and (DataSet.FieldByName('日期').AsDateTime = Date()) then Accept := True;
Access:
adodataset3.Filter:='卡号='+quotedstr(edit1.text)+' and '+'日期<#'+FormatDateTime('yyyy-MM-dd hh:mm:ss',date)+ '# and '+'打印=0';SQLServer:
adodataset3.Filter:='卡号='+quotedstr(edit1.text)+' and '+'日期<Convert(DateTime,'+FormatDateTime('yyyy-MM-dd hh:mm:ss',date)+ ') and '+'打印=0';
procedure TForm1.AdoDataSet1FilterRecord(DataSet: TDataSet; var Accept: Boolean);begin
Accept :=False;
if (DataSet.FieldByName('卡号').AsString = edit1.text) and (DataSet.FieldByName('打印').AsString = '0') and (DataSet.FieldByName('日期').AsDateTime = Date()) then
Accept := True;
end;
'日期<' + #39 + FormatDateTime('yyyy/mm/dd', date()) + #39