if checkbox1.Checked then
with dm.query2 do
begin
close;
sql.Clear;
sql.Add('select * from brrowinfo where 借阅日期> #' + formatdatetime('yyyy-mm-dd',datetimepicker1.Date) + '# and 借阅日期< #' + formatdatetime('yyyy-mm-dd',datetimepicker1.Date) + '#');
open;
end;
出错提示:'#'附近有语法错误!!
with dm.query2 do
begin
close;
sql.Clear;
sql.Add('select * from brrowinfo where 借阅日期> #' + formatdatetime('yyyy-mm-dd',datetimepicker1.Date) + '# and 借阅日期< #' + formatdatetime('yyyy-mm-dd',datetimepicker1.Date) + '#');
open;
end;
出错提示:'#'附近有语法错误!!
ShowMessage出来看看
Close;
SQL.Clear;
SQL.Add('select * from a where 借阅日期>=:startrq and 借阅日期<=:endrq');
Parameters.ParamByName('startrq').Value:=formatdatetime('yyyy-mm-dd',form1.DateTimePicker1.Date);
Parameters.ParamByName('endrq').Value:=formatdatetime('yyyy-mm-dd',form1.DateTimePicker2.Date);
Open;
end;
if checkbox1.Checked then
with dm.query2 do
begin
close;
sql.Clear;
sql.Add('select * from brrowinfo where 借阅日期> '+'#' + formatdatetime('yyyy-mm-dd',datetimepicker1.Date) +'#'+' and 借阅日期< '+'#' + formatdatetime('yyyy-mm-dd',datetimepicker1.Date) +'#'+');
open;
end;
with dm.query2 do
begin
close;
sql.Clear;
sql.Add('select * from brrowinfo where 借阅日期> ' + formatdatetime('yyyy-mm-dd',datetimepicker1.Date) + '借阅日期' + formatdatetime('yyyy-mm-dd',datetimepicker1.Date) );
open;
end;试试!