小弟最近重装了操作系统,当然,VB6也跟着重装了重装系统前,下面这段代码用得好好的,重装后,打开之前保存的工程文件,发现这段代码无效了,这是怎么回事呢?Private Sub cmdDelete2_Click()
If MSHFlexGrid2.Clip = "" Then
Exit Sub
Else
Dim db As Database
Set db = Workspaces(0).OpenDatabase(App.Path & "\mydb.mdb")
If MSHFlexGrid2.Clip <> "" Then
Dim sql1 As String
If cboPtcname.Text = "" And List1.Text <> "" Then
sql1 = "delete * from perday where 站='" & List1.Text & "' and 今='" & MSHFlexGrid2.Clip & "'"
ElseIf List1.Text = "" And cboPtcname.Text <> "" Then
sql1 = "delete * from perday where 站='" & cboPtcname.Text & "' and 今='" & MSHFlexGrid2.Clip & "'"
End If
db.Execute sql1
End If
End If
MsgBox "清理成功!", vbOKOnly, "提示"
Dim sql As String
If cboPtcname.Text = "" And List1.Text <> "" Then
sql = "select distinct 今 from perday where 站='" & List1.Text & "' order by 今 desc"
ElseIf List1.Text = "" And cboPtcname.Text <> "" Then
sql = "select distinct 今 from perday where 站='" & cboPtcname.Text & "' order by 今 desc"
End If
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & App.Path & "\mydb.mdb;" & "Persist Security Info=False"
conn.Open
rs.Open sql, conn, adOpenKeyset, adLockOptimistic
Set MSHFlexGrid2.DataSource = rs
rs.Close
conn.Close
Set conn = Nothing
Set rs = Nothing
End Sub点了“cmdDelete2”这个按钮之后,不起任何作用是不是编译环境出了什么问题,请老手教我!!!
If MSHFlexGrid2.Clip = "" Then
Exit Sub
Else
Dim db As Database
Set db = Workspaces(0).OpenDatabase(App.Path & "\mydb.mdb")
If MSHFlexGrid2.Clip <> "" Then
Dim sql1 As String
If cboPtcname.Text = "" And List1.Text <> "" Then
sql1 = "delete * from perday where 站='" & List1.Text & "' and 今='" & MSHFlexGrid2.Clip & "'"
ElseIf List1.Text = "" And cboPtcname.Text <> "" Then
sql1 = "delete * from perday where 站='" & cboPtcname.Text & "' and 今='" & MSHFlexGrid2.Clip & "'"
End If
db.Execute sql1
End If
End If
MsgBox "清理成功!", vbOKOnly, "提示"
Dim sql As String
If cboPtcname.Text = "" And List1.Text <> "" Then
sql = "select distinct 今 from perday where 站='" & List1.Text & "' order by 今 desc"
ElseIf List1.Text = "" And cboPtcname.Text <> "" Then
sql = "select distinct 今 from perday where 站='" & cboPtcname.Text & "' order by 今 desc"
End If
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & App.Path & "\mydb.mdb;" & "Persist Security Info=False"
conn.Open
rs.Open sql, conn, adOpenKeyset, adLockOptimistic
Set MSHFlexGrid2.DataSource = rs
rs.Close
conn.Close
Set conn = Nothing
Set rs = Nothing
End Sub点了“cmdDelete2”这个按钮之后,不起任何作用是不是编译环境出了什么问题,请老手教我!!!
解决方案 »
- 装了2010的.Net不能装VB6.0?
- 如何實現兩個ListView拖拽功能.像资源管理器的拖拽功能一樣
- 求助关于数据库中提取日期时间的问题
- **************使用setup factory打包的时候,如何向setup factory工程中添加一个目录?*******
- 求教关于listbox的问题
- VB怎样将提示信息至另一程序顶层显示
- AT命令中读短消息和删短消息?
- 那里有卖比较好用的加密狗的?硬件加密,
- 我想用wise或install shield, 做vb6的安装盘,我都需要打包什么文件啊?
- 如何用flash控件获取flash文件的原始尺寸大小,以便设置控件大小
- sql存储过程出错-临时表,请leftie兄看看
- mdi窗体上如何能放上控件呢?比如按钮,组合框等等。
Exit Sub设置断点,调试看看,MSHFlexGrid2.Clip是否真的等于"",真的等于""就退出过程了。
查看MSHFlexGrid2的数据来自哪里?
msgbox "11111111"
If MSHFlexGrid2.Clip = "" Then
msgbox "22222222"
Exit Sub
Else
msgbox "33333333"
'
'
'
看看,跳出哪个对话框,如果一个都没有,那么是这个过程名与按钮名不一致,如弹出11111对话框说明,这个没问题,如果跳出222222对话框,说明MSHFlexGrid2.Clip = "" ,……