strsql = "insert into s_info(s_rcbase,s_rjava,s_rc,s_rdbase)values(Text2.Text,Text3.Text,Text4.Text,Text5.Text) where s_no='" & Trim(Text1.Text) & "'"
Set myrecord = myconn.Execute(strsql)
If Not myrecord.EOF Then这个句子那儿有错啊,提示:在where处有错啊
Set myrecord = myconn.Execute(strsql)
If Not myrecord.EOF Then这个句子那儿有错啊,提示:在where处有错啊
If ((Text1.Text = "") Or (Len(Text1.Text) <> 10)) Then
MsgBox "请输入十位数的学号!", vbInformation + vbOKOnly, "系统提示!"
Exit Sub
End If
strsql = "insert into s_info(s_rcbase,s_rjava,s_rc,s_rdbase)values('" & Text2.Text & "','" & Text3.Text & "','" & Text4.Text & "','" & Text5.Text & ") where s_no='" & Trim(Text1.Text) & "'"
Set myrecord = myconn.Execute(strsql)
If Not myrecord.EOF Then
myrecord.Update
Else
MsgBox "对不起!没有您检索的学号!", vbInformation + vbOKOnly, "检索警告!"
strsql = "insert into s_info(s_rcbase,s_rjava,s_rc,s_rdbase)values('" & Text2.Text & "','" & Text3.Text & "','" & Text4.Text & "','" & Text5.Text & "') where s_no='" & Trim(Text1.Text) & "'"
insert into a
select * from b
这个时候可以在select 的时候做条件限制.