请问如果查找成功怎么代码写入数据表aa呀,并且怎么样写代码把表字段显示在界面上
procedure Tfrm_kaoqinji.btn_enterClick(Sender: TObject);
var s:string;
begin
s:='select 工号 from usermsg ';
if edt_id.Text <>'' then
s:=s+ ' where 工号='''+edt_id.Text+'''';
with qy_kaoqinji do
begin
Close ;
SQL.Clear ;
SQL.Add(s);
try
Open ;
except
ExecSQL ;
end;
end;
procedure Tfrm_kaoqinji.btn_enterClick(Sender: TObject);
var s:string;
begin
s:='select 工号 from usermsg ';
if edt_id.Text <>'' then
s:=s+ ' where 工号='''+edt_id.Text+'''';
with qy_kaoqinji do
begin
Close ;
SQL.Clear ;
SQL.Add(s);
try
Open ;
except
ExecSQL ;
end;
end;
insert into table2 select a,b from table where .... // 插入一个表