数据保存问题,谢谢了.
游子 2007-09-17 08:50:07 下面是我保存的代码:
Dim strSQL As String
Dim cnn As New ADODB.Connection
Dim rs As New ADODB.Recordset
rs.LockType = adLockOptimistic
rs.CursorType = adOpenKeyset
cnn.CursorLocation = adUseClient
cnn.connectionstring = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\Showup.mdb"
cnn.Open
rs.Open "SELECT 字段1,字段2,字段3,时间 FROM code where 字段2='" & Text2.Text & "' & 字段3='" & Text3.Text & "' ", cnn
If rs.EOF = False Then
MsgBox "已经存在该条码."
Else
rs.AddNew
With rs
.Fields("字段1") = Text1.Text
.Fields("字段2") = Text2.Text
.Fields("字段3") = Text3.Text
.Fields("时间") = Text4.Text
.Update
End With
MsgBox "保存成功"
End If
cnn.Close
但是我现在有个要求是,在一个表中,字段1保存的数据可以重复,而字段2和字段3保存的时候数据不可以重复,如果有重复的提示.但我不知道怎么写了,谢谢.急,在线等.