代码如下:
Public cust As Recordset, cuswork As Workspace
Private Sub Command1_Click()
Dim conn As ADODB.Connection
Dim cmd As ADODB.Command
Dim rs As ADODB.Recordset
Set conn = New ADODB.Connection
Set cmd = New ADODB.Command
conn.ConnectionString = "Provider=MSDAORA.1;Password=pims;User ID=pims;Data Source=pims;Persist Security Info=True"
conn.Open
Set cmd.ActiveConnection = conn
cmd.CommandType = adCmdStoredProc
cmd.CommandText = "p_test" & "(2)"
Set rs = cmd.Execute
MsgBox "good"
End SubPrivate Sub Form_Load()
Set cuswork = Workspaces(0)
'Set cust = Adodc1.Recordset
cuswork.BeginTrans
End SubPrivate Sub Form_Unload(Cancel As Integer)
If MsgBox("save all changes?", vbQuestion + vbYesNo, "save changes") = vbYes Then
cuswork.CommitTrans
Else
cuswork.Rollback
End If
End Sub
调用的是oracle中的一个简单的insert存储过程
每次退出程序提问时我选择no时,数据库中却都插入了新的数据哦???
哪里出问题了???
Public cust As Recordset, cuswork As Workspace
Private Sub Command1_Click()
Dim conn As ADODB.Connection
Dim cmd As ADODB.Command
Dim rs As ADODB.Recordset
Set conn = New ADODB.Connection
Set cmd = New ADODB.Command
conn.ConnectionString = "Provider=MSDAORA.1;Password=pims;User ID=pims;Data Source=pims;Persist Security Info=True"
conn.Open
Set cmd.ActiveConnection = conn
cmd.CommandType = adCmdStoredProc
cmd.CommandText = "p_test" & "(2)"
Set rs = cmd.Execute
MsgBox "good"
End SubPrivate Sub Form_Load()
Set cuswork = Workspaces(0)
'Set cust = Adodc1.Recordset
cuswork.BeginTrans
End SubPrivate Sub Form_Unload(Cancel As Integer)
If MsgBox("save all changes?", vbQuestion + vbYesNo, "save changes") = vbYes Then
cuswork.CommitTrans
Else
cuswork.Rollback
End If
End Sub
调用的是oracle中的一个简单的insert存储过程
每次退出程序提问时我选择no时,数据库中却都插入了新的数据哦???
哪里出问题了???
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货