Private Sub cmdDelete_Click()
Dim txtSQL As String
Dim intCount As Integer
Dim mrc As ADODB.Recordset
Dim MsgText As String
If msgList.Rows > 1 Then
If MsgBox("真的要删除款号为" & Trim(msgList.TextMatrix(msgList.Row, 1)) & "的记录吗?", vbOKCancel + vbExclamation, "警告") = vbOK Then
intCount = msgList.Row
txtSQL = "delete from dm_wz where dm ='" & Trim(msgList.TextMatrix(intCount, 1)) & "'"
Set mrc = ExecuteSQL(txtSQL, MsgText)
Unload frmWZSetup
frmWZSetup.txtSQL = "select * from dm_wz"
frmWZSetup.Show
End If
End If
End Sub
Dim txtSQL As String
Dim intCount As Integer
Dim mrc As ADODB.Recordset
Dim MsgText As String
If msgList.Rows > 1 Then
If MsgBox("真的要删除款号为" & Trim(msgList.TextMatrix(msgList.Row, 1)) & "的记录吗?", vbOKCancel + vbExclamation, "警告") = vbOK Then
intCount = msgList.Row
txtSQL = "delete from dm_wz where dm ='" & Trim(msgList.TextMatrix(intCount, 1)) & "'"
Set mrc = ExecuteSQL(txtSQL, MsgText)
Unload frmWZSetup
frmWZSetup.txtSQL = "select * from dm_wz"
frmWZSetup.Show
End If
End If
End Sub
ExecuteSQL
应该是ADODB
看语法应该是VB
ado连接