2,497
社区成员
发帖
与我相关
我的任务
分享
procedure TForm1.Button1Click(Sender: TObject);
begin
with ADOQuery1 do
begin
Close;//Active:=False;
SQL.Clear;
SQL.Add('insert into error_table(id,error_id) values(:str,:str1)');
Parameters.ParamByName('str').value:=strtoint(edit1.Text);
Parameters.ParamByName('str1').value:=edit2.Text;
ExecSQL;
End;
end;
with ADOQuery1 do
begin
Close;
SQL.Clear;
...
Open;//ExecSQL;看SQL语句而定这里是Open还是ExecSQL
end;
procedure TForm1.Button1Click(Sender: TObject);
begin
ADOQuery1.Close;
ADOQuery1.SQL.Clear;
ADOQuery1.SQL.Add('insert into error_table(id,error_id) values(:str,:str1)');
ADOQuery1.Parameters.ParamByName('str').value:=strtoint(edit1.Text);
ADOQuery1.Parameters.ParamByName('str1').value:=edit2.Text;
ADOQuery1.ExecSQL;
ADOQuery1.Active:=false;
end;