procedure Tyhdcx_Form.BitBtn1Click(Sender: TObject); var str:string; begin str:='select * form yhgz where id>0'; if edit1.Text<>'' then begin str:=str+'and yhmc='''+edit1.text+''''; end; if edit2.Text<>'' then begin str:=str+'and xm='''+edit2.text+''''; end; (datetimepicker2.DateTime)<>0 then str:=str+'and yhrq=between '''+datetostr(datetimepicker1.date)+''' and '''+datetostr(datetimepicker2.date) '''';adoquery1.SQL.Add(str); end;
这样改: procedure Tyhdcx_Form.BitBtn1Click(Sender: TObject); var str:string; begin str:='select * form yhgz where id>0'; if edit1.Text<>'' then begin str:=str+'and yhmc='''+edit1.text+''''; end; if edit2.Text<>'' then begin str:=str+'and xm='''+edit2.text+''''; end; (datetimepicker2.DateTime)<>0 then str:=str+'and yhrq between datetostr(datetimepicker1) and datetostr(datetimepicker2) ';adoquery1.SQL.Add(str); end;
应变为
str:=str+'and xm='''+edit2.text+'''
str:=str+'and xm='''+edit2.text+''''
var str:string;
begin
str:='select * form yhgz where id>0';
if edit1.Text<>'' then
begin
str:=str+'and yhmc='''+edit1.text+'''';
end;
if edit2.Text<>'' then
begin
str:=str+'and xm='''+edit2.text+'''';
end;
(datetimepicker2.DateTime)<>0 then str:=str+'and yhrq=between '''+datetostr(datetimepicker1.date)+''' and '''+datetostr(datetimepicker2.date) '''';adoquery1.SQL.Add(str);
end;
str:=str+'and xm="'+edit2.text+'"'
str:=str+'and yhmc='+''''+edit1.text+'''';str:=str+'and xm='+''''+edit2.text+'''';datetimepicker1.datedatetimepicker2.date
str:=str+'and xm=''+edit2.text+''';
str:=str+'and yhmc=''+edit1.text+''';
str:=str+'and yhmc='''+edit1.text+'''';
str:=str+'and xm='''+edit1.text+'''';
procedure Tyhdcx_Form.BitBtn1Click(Sender: TObject);
var str:string;
begin
str:='select * form yhgz where id>0';
if edit1.Text<>'' then
begin
str:=str+'and yhmc='''+edit1.text+'''';
end;
if edit2.Text<>'' then
begin
str:=str+'and xm='''+edit2.text+'''';
end;
(datetimepicker2.DateTime)<>0 then str:=str+'and yhrq between datetostr(datetimepicker1) and datetostr(datetimepicker2) ';adoquery1.SQL.Add(str);
end;