With g_Conn
.ConnectionString = "Data Source=equip"
.Open
End With
g_Conn是一全局变量Private Sub AddNewOper()
Dim rs_OperEquip As New ADODB.Recordset
Dim rs_Oper As New ADODB.Recordset
rs_Oper.Open "operinfo", g_Conn, adOpenKeyset, adLockOptimistic g_Conn.BeginTrans
With rs_Oper
.Filter = "operid='" & txtOperId & "'"
If .BOF And .EOF Then
.AddNew
!OperId = txtOperId
!oname = txtOperName
.Update
'MsgBox "操作者编号已经存在请确定输入正确", vbCritical, "Alarm"
'.Close
'Set rs_Oper = Nothing
'Exit Sub
End If
'.AddNew
'!OperId = txtOperId
'!oname = txtOperName
'!eqid = txtEqId
'!proline = txtProLine
End With
With rs_OperEquip
.Open "operequip", g_Conn, adOpenKeyset, adLockOptimistic
.AddNew
!OperId = txtOperId
!eqid = txtEqId
!proline = txtProLine
.Update
End With
cnn_Oper.CommitTrans
End Sub
.ConnectionString = "Data Source=equip"
.Open
End With
g_Conn是一全局变量Private Sub AddNewOper()
Dim rs_OperEquip As New ADODB.Recordset
Dim rs_Oper As New ADODB.Recordset
rs_Oper.Open "operinfo", g_Conn, adOpenKeyset, adLockOptimistic g_Conn.BeginTrans
With rs_Oper
.Filter = "operid='" & txtOperId & "'"
If .BOF And .EOF Then
.AddNew
!OperId = txtOperId
!oname = txtOperName
.Update
'MsgBox "操作者编号已经存在请确定输入正确", vbCritical, "Alarm"
'.Close
'Set rs_Oper = Nothing
'Exit Sub
End If
'.AddNew
'!OperId = txtOperId
'!oname = txtOperName
'!eqid = txtEqId
'!proline = txtProLine
End With
With rs_OperEquip
.Open "operequip", g_Conn, adOpenKeyset, adLockOptimistic
.AddNew
!OperId = txtOperId
!eqid = txtEqId
!proline = txtProLine
.Update
End With
cnn_Oper.CommitTrans
End Sub
解决方案 »
- textbox的Change和listview增量查询,急急....
- 关于sqlserver货币型字段显示的问题
- 如何每间隔一段时间运行一次程序------急
- 刚才部门经理问我的一个VB问题,我不懂,急
- 高手指教SQLExecDirect和SQLGetDiagRec!
- 求救:自己做了一个打印票据控件,为什么票据打印机打印出一张后,后面紧接两张空白的票据????
- 为什么这条语句在SQL分析器里用没事..但调到VB里用就有事了..?
- 如何使用MSCOMM控件读取串口二进制数据,并保存成二进制格式的文件!最好有代码!在线等候!!
- 请大家多讲讲有关DHTML这个控件的用法和用途
- 新手请教!vb操作数据库问题
- 2000 Server 下怎样让自己的程序在 Login 界面前就启动~~~谢谢~~~
- ???如何在LISTBOX第一行产生按钮那样的效果???
With g_Conn
.ConnectionString = "Data Source=equip"
.Open
End With
打开是不是运行正确?
不同的是我是另外定义了connection对象在form1中代码如下:
private cnn as new adodb.connectionPrivate Sub AddNewOper()
Dim rs_OperEquip As New ADODB.Recordset
Dim rs_Oper As New ADODB.Recordset With Cnn
.ConnectionString = "Data Source=equip"
.Open
End With
rs_Oper.Open "operinfo", Cnn, adOpenKeyset, adLockOptimistic Cnn.BeginTrans
With rs_Oper
.Filter = "operid='" & txtOperId & "'"
If .BOF And .EOF Then
.AddNew
!OperId = txtOperId
!oname = txtOperName
.Update
End If End With
With rs_OperEquip
.Open "operequip", Cnn, adOpenKeyset, adLockOptimistic
.AddNew
!OperId = txtOperId
!eqid = txtEqId
!proline = txtProLine
.Update
End With
cnn.CommitTrans
End Sub