请教各位大侠
以下句子出现了什么错误
usernamestr = Text4.Text
agestr = Text5.Text
addressstr = Text6.Text
emailstr = Text7.Text
conn.Execute ("insert into userinfo(username,age,address,email) values('&trim(usernamestr)&','&trim(agestr)&','&trim(addressstr)&','&trim(emailstr)&')")
rs.Update
以下句子出现了什么错误
usernamestr = Text4.Text
agestr = Text5.Text
addressstr = Text6.Text
emailstr = Text7.Text
conn.Execute ("insert into userinfo(username,age,address,email) values('&trim(usernamestr)&','&trim(agestr)&','&trim(addressstr)&','&trim(emailstr)&')")
rs.Update
With rs
.AddNew
.Fields("username") = Text4.Text
.Fields("age") = Text5.Text
.Fields("address") = Text6.Text
.Fields("email") = Text7.Text
.Update
End With
或者
conn.Execute ("insert into userinfo(username,age,address,email)values('" & Trim(Text4.Text) & "','" & Trim(Text5.Text) & "','" & Trim(Text6.Text) & "','" & Trim(Text7.Text) & "')")自己给自己顶了
conn.execute strsql
不要用这种格式调用sql,能自己把自己搞昏头
strsql=' ';
conn.execute strsql;