'select * from db_rkd where shid='''+Edit1.Text+''' and ('''+rq+'''>=''2010-8-22'' and '''+rq+'''<=''2010-8-22'')';
var sqlstr: string; begin ... sqlstr := 'select * from db_rkd where shid = ' + QuotedStr(Edit1.Text) + ' and rq >= ' + QuotedStr(FormateDateTime('YYYY-MM-DD', DateTimePicker1.Date)) + ' and rq <= ' + QuotedStr(FormateDateTime('YYYY-MM-DD', DateTimePicker2.Date)); ... end;
var sqlstr: string; begin ... sqlstr := Format('select * from db_rkd where shid=''%s'' and (rq>=''%s'' and rq<=''%s'');', [Trim((Edit1.Text), DateToStr(dtp1.Date), DateToStr(dtp1.Date)]); ... end; 我有点奇怪的是,你为什么不用between而要用<= >=
var
sqlstr: string;
begin
...
sqlstr := 'select * from db_rkd where shid = ' + QuotedStr(Edit1.Text) +
' and rq >= ' + QuotedStr(FormateDateTime('YYYY-MM-DD', DateTimePicker1.Date)) +
' and rq <= ' + QuotedStr(FormateDateTime('YYYY-MM-DD', DateTimePicker2.Date));
...
end;
sqlstr: string;
begin
...
sqlstr := Format('select * from db_rkd where shid=''%s'' and (rq>=''%s'' and rq<=''%s'');', [Trim((Edit1.Text), DateToStr(dtp1.Date), DateToStr(dtp1.Date)]);
...
end;
我有点奇怪的是,你为什么不用between而要用<= >=