我用ADO连接ACCESS数据库,有添加了一个ADOQuery这个组建
现在要在ADOQuery这个组建的SQL属性里面添加sql语句,我因为想写入数据库蛋是这样写不对
请各位指教。我这样的insert into table (name,sex,address) values ("edit1.Text","edit2.Text","edit3.Text")各位指教一下阿
现在要在ADOQuery这个组建的SQL属性里面添加sql语句,我因为想写入数据库蛋是这样写不对
请各位指教。我这样的insert into table (name,sex,address) values ("edit1.Text","edit2.Text","edit3.Text")各位指教一下阿
procedure TForm1.Button1Click(Sender: TObject);
begin
adoquery1.close;
adoquery1.sql.clear;
adoquery1.sql.text:='insert into table (name,sex,tel,address,memo1) values ('"+edit1.Text+"','"+edit2.Text+"',"'+edit3.Text+'","'+edit4.Text+'","'+Memo1.Text+'")';
adoquery1.open;
end;这行有错adoquery1.sql.text:='insert into table (name,sex,tel,address,memo1) values ('"+edit1.Text+"','"+edit2.Text+"',"'+edit3.Text+'","'+edit4.Text+'","'+Memo1.Text+'")';