sql语句没有问题,我用其他的QUERY执行同样的语句没有问题,可以用
procedure TP_F_hxdy.Button1Click(Sender: TObject);
begin
strdate:='';
if strtoint(formatdatetime('MM',datetimepicker2.date))<10 then
strdate:='to_date('''+formatdatetime('dd-m'''+'月'+'''-yyyy',datetimepicker2.date)+''')'
else
strdate:='to_date('''+formatdatetime('dd-mm'''+'月'+'''-yyyy',datetimepicker2.date)+''')';
with query1 do
begin
close;
sql.Clear ;
s:='';
s:='select * from c_clb where scrq='+strdate+' and jw='''+combobox1.Text+''' ';
sql.Add(s);
open;
end;