从表中删除一条记录
怎吗实现不料我的代码是我好着急啊
Dim rsResult As ADODB.Recordset, cnconn As ADODB.Connection
Dim strSQL As String
Set rsResult = New ADODB.Recordset
Set cnconn = New ADODB.Connection
cnconn.Open sStrProvider
strSQL = "Select BOM_CodeNO From Costume_BOMMemo Where BOM_CodeNO like '" & Trim(txtCodeNO.Text) & "'"
rsResult.Open strSQL, cnconn, adOpenKeyset, adLockOptimistic
If Button = 2 Then
If MsgBox("确定要删除这条记录吗?", 36, "注意!") = 6 Then
strSQL = " Delete from Costume_BOM where BOM_CodeNO='" & Trim(txtCodeNO.Text) & "' and BOM_Type='" & Trim(txtCodeNO.Text) & "' and BOM_NO='" & Trim(txtCodeNO.Text) & "' "
cnconn.Execute strSQL
SGrid.Refresh
End If
End If
怎吗实现不料我的代码是我好着急啊
Dim rsResult As ADODB.Recordset, cnconn As ADODB.Connection
Dim strSQL As String
Set rsResult = New ADODB.Recordset
Set cnconn = New ADODB.Connection
cnconn.Open sStrProvider
strSQL = "Select BOM_CodeNO From Costume_BOMMemo Where BOM_CodeNO like '" & Trim(txtCodeNO.Text) & "'"
rsResult.Open strSQL, cnconn, adOpenKeyset, adLockOptimistic
If Button = 2 Then
If MsgBox("确定要删除这条记录吗?", 36, "注意!") = 6 Then
strSQL = " Delete from Costume_BOM where BOM_CodeNO='" & Trim(txtCodeNO.Text) & "' and BOM_Type='" & Trim(txtCodeNO.Text) & "' and BOM_NO='" & Trim(txtCodeNO.Text) & "' "
cnconn.Execute strSQL
SGrid.Refresh
End If
End If
解决方案 »
- 关于继承窗口的句柄问题(高手进来)
- 【严重恭喜】恭喜阿泰同学完成人生系统升级------喜添贵子呀!!!
- Help!!RichTextBox中插入gif动画?
- 新建立表问题~!急救,在线等,谢谢了先!!!
- 100分解决一个小问题!!!配置类型不正确,系统无法开始服务器进程
- 在线等待,请教一个控件问题,UserControl.AsyncRead出错
- ADO记录集的过滤问题!
- 很急,请高手指点!在线等。
- 简单问题50分 如何启动Splash?
- 关于winsock:如果有一台主机,地址202.95.135.124,它是它所属的局域网的网关,它所属的局域网有另一台主机,内部地址192.192.192.32,我如何请求与192.192.192.32建立连接?
- 在使用vb自带的打包和展开对程序打包时出现“路径不包含文件名”的错误请问是何原因
- 能否直接在LISTVIEW上进行编辑?
改成:
if msgbox("确定要删除这条记录码?",vbyesno+vbquestion,"提示")=vbyes then
试试
Dim cnconn As ADODB.Connection
Dim strSQL As String
Set rsResult = New ADODB.Recordset
Set cnconn = New ADODB.Connection
cnconn.Open "连接数据库"
If Button = 2 Then
If MsgBox("确定要删除这条记录吗?", 36, "注意!") = 6 Then
strSQL.open" Delete from Costume_BOM where BOM_CodeNO='" & Trim(txtCodeNO.Text) & "' and BOM_Type='" & Trim(txtCodeNO.Text) & "' and BOM_NO='" & Trim(txtCodeNO.Text) & "' ",cnconn, adOpenKeyset, adLockOptimistic
cnconn.Execute strSQL
SGrid.Refresh
End If
End If