sql 和ACCESS数据库查询中有那些不同以下代码在ACCESS中正常在sql 运行不正确
Dim rs1 As New ADODB.Recordset
rs1.Open "select * from 原料合格品档案 where 炉号='" & Trim(Text1.Text) & "'and 垛位 ='" + Combo3.Text + "' ", cnn, adOpenKeyset, adLockOptimistic
If rs1.RecordCount > 0 Then
Dim snum As Integer
snum = Val(rs1.Fields("根数")) + Val(Trim(Text4.Text))
rs1.Update
rs1.Fields("根数") = snum
rs1.Update
Dim rs1 As New ADODB.Recordset
rs1.Open "select * from 原料合格品档案 where 炉号='" & Trim(Text1.Text) & "'and 垛位 ='" + Combo3.Text + "' ", cnn, adOpenKeyset, adLockOptimistic
If rs1.RecordCount > 0 Then
Dim snum As Integer
snum = Val(rs1.Fields("根数")) + Val(Trim(Text4.Text))
rs1.Update
rs1.Fields("根数") = snum
rs1.Update
Dim rs1 As New ADODB.Recordset
rs1.Open "select * from 原料合格品档案 where 炉号='" & Trim(Text1.Text) & "'and 垛位 ='" + Combo3.Text + "' ", cnn, adOpenKeyset, adLockOptimistic
If rs1.RecordCount > 0 Then
Dim snum As Integer
snum = Val(rs1.Fields("根数")) + Val(Trim(Text4.Text))
'rs1.Update
rs1.Fields("根数") = snum
rs1.Update
设置连接对象的CursorLocation属性为 UseClient