var Vstr: string;
begin
Vstr:='Select * from employee where'
if EditName<>'' then Vstr:=Vstr+' empname='''+Editname.text+'''';
if Editno<>'' then Vstr:=Vstr+' and empno='+Editno.text;
with query1 do
begin
close;
sql.clear;
sql.add(vstr);
open;
end;end;
begin
Vstr:='Select * from employee where'
if EditName<>'' then Vstr:=Vstr+' empname='''+Editname.text+'''';
if Editno<>'' then Vstr:=Vstr+' and empno='+Editno.text;
with query1 do
begin
close;
sql.clear;
sql.add(vstr);
open;
end;end;
工号
怎么做
我有一个员工表想按工号和人名查询出想要的信息,怎么做呢?