procedure Tddfform.btnInquClick(Sender: TObject);
var
bd,ed:tdatetime;
begin
bd := DateTimePicker1.datetime;
ed := DateTimePicker2.datetime;
adoquery1.close;
adoquery1.SQL.Clear;
adoquery1.sql.Add('select pjbh,pjmc,pjgg,dw,dj,sl,zj,bm,lyr,llrq,pjlb,czy,bz from ff');
adoquery1.sql.add('where llrq >= :bd and llrq <= :ed');
adoquery1.Open;
end.
这是热心网友帮我修改过的代码。可是我查询出来以后。DBGrid不显示根据条件查询出来的结果
var
bd,ed:tdatetime;
begin
bd := DateTimePicker1.datetime;
ed := DateTimePicker2.datetime;
adoquery1.close;
adoquery1.SQL.Clear;
adoquery1.sql.Add('select pjbh,pjmc,pjgg,dw,dj,sl,zj,bm,lyr,llrq,pjlb,czy,bz from ff');
adoquery1.sql.add('where llrq >= :bd and llrq <= :ed');
adoquery1.Open;
end.
这是热心网友帮我修改过的代码。可是我查询出来以后。DBGrid不显示根据条件查询出来的结果
bd := DateTimePicker1.datetime;
ed := DateTimePicker2.datetime;
上面两句就是赋值了吧
ADOQuery1.Parameters.ParamByName('bd').Value
ADOQuery1.Parameters.ParamByName('ed').Value
var
bd,ed:string; //改了
begin
bd := formatdatetime('yyy-mm-dd',datetimepicker1.date); //改了
ed := formatdatetime('yyy-mm-dd',datetimepicker2.date); //改了
adoquery1.close;
adoquery1.SQL.Clear;
adoquery1.sql.Add('select pjbh,pjmc,pjgg,dw,dj,sl,zj,bm,lyr,llrq,pjlb,czy,bz from ff');
adoquery1.sql.add('where llrq >='''+ :bd+ ''' and llrq <= '''+:ed''''); //改了
adoquery1.Open;
end.
procedure Tddfform.btnInquClick(Sender: TObject);
var
bd,ed:tdatetime;
begin
bd := DateTimePicker1.datetime;
ed := DateTimePicker2.datetime;
adoquery1.close;
adoquery1.SQL.Clear;
adoquery1.sql.Add('select pjbh,pjmc,pjgg,dw,dj,sl,zj,bm,lyr,llrq,pjlb,czy,bz from ff');
adoquery1.sql.add('where llrq >= :bd and llrq <= :ed');
adoquery1.Parameters.ParamByName('bd').Value := bd; //这里赋值
adoquery1.Parameters.ParamByName('ed').Value := ed;
adoquery1.Open;
end.
兄弟。你的代码管用。O YE。搞定。太谢谢你拉~哈哈~~~~
begin
adoquery1.close;
adoquery1.SQL.Clear;
adoquery1.sql.Add('select pjbh,pjmc,pjgg,dw,dj,sl,zj,bm,lyr,llrq,pjlb,czy,bz from ff');
adoquery1.sql.add(format('where llrq between #%s# ', [DateTimeToStr(datetimepicker1.Datetime)]));
adoquery1.sql.add(format('and #%s#',[DateToStr(datetimepicker2.Date)]));
adoquery1.Open;
end;