不使自动编号 是自己写的索引值 不是自动编号有下面的小例子在网络中同时运行 该怎么实现Private Sub Command1_Click() Set breedconn = New ADODB.Connection breedconn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=breed1;Data Source= cyf1" breedconn.CursorLocation = adUseServer breedconn.ConnectionTimeout = 15 breedconn.Open For i = 0 To 10000 breedconn.BeginTrans If rs1.State = adStateOpen Then rs1.Close rs1.Open "select * from www order by id desc", breedconn, adOpenKeyset, adLockOptimistic j = rs1.Fields("id") rs1.AddNew rs1.Fields("id") = j + 1 rs1.Fields("name") = Text1.Text rs1.Update breedconn.CommitTrans Next End Sub
把 rs1.Open "select * from www order by id desc", breedconn, adOpenKeyset, adLockOptimistic 改为 rs1.Open "select * from www order by id desc", breedconn, adOpenKeyset, adLockPessimistic 试试
写成一句即可 breedconn.Execute "insert into www(id,name) select max(id)+1,'" & Trim(Text1.Text) & "' from www" 或者将ID字段设为自动增长列
Set breedconn = New ADODB.Connection
breedconn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=breed1;Data Source= cyf1"
breedconn.CursorLocation = adUseServer
breedconn.ConnectionTimeout = 15
breedconn.Open
For i = 0 To 10000
breedconn.BeginTrans
If rs1.State = adStateOpen Then rs1.Close
rs1.Open "select * from www order by id desc", breedconn, adOpenKeyset, adLockOptimistic
j = rs1.Fields("id")
rs1.AddNew
rs1.Fields("id") = j + 1
rs1.Fields("name") = Text1.Text
rs1.Update
breedconn.CommitTrans
Next
End Sub
2、改breedconn.CursorLocation = adUseClient 试试
rs1.Open "select * from www order by id desc", breedconn, adOpenKeyset, adLockOptimistic
改为
rs1.Open "select * from www order by id desc", breedconn, adOpenKeyset, adLockPessimistic
试试
breedconn.Execute "insert into www(id,name) select max(id)+1,'" & Trim(Text1.Text) & "' from www"
或者将ID字段设为自动增长列