怎么会说没有SELECT CASE 或则是END SELECT

jjs008 2004-04-29 10:12:06
具体程序是这样的:
Public Sub Grid_Delete(ByVal grid As MSHFlexGrid, ByVal choice As Integer)
Select Case choice
Case 1
Dim Msg As String
Dim strSQL As String
Dim myTempRow As Integer
Call check_link

If fRow = 0 Then
MsgBox "请选择要修改的行!", vbOKOnly + vbInformation, "注意"
Exit Sub
End If
Msg = MsgBox("确定删除当前纪录吗?", vbYesNo + vbInformation)
If Msg = vbNo Then
Exit Sub
End If

'删除当前记录
strSQL = "DELETE * FROM Customer WHERE ORDERN='" & Grid1.TextMatrix(fRow, 0) & "'"

fCnn.Execute strSQL


If Grid1.Rows = 2 Then
Grid1.Rows = 1
Else
Grid1.RemoveItem fRow
End If
myTempRow = Grid1.Rows - 1
If myTempRow = 0 Then
Else
If fRow <= myTempRow Then
Grid1.TextMatrix(fRow, 0) = ""
End If
fRow = myTempRow
Grid1.TextMatrix(fRow, 0) = "*"

Call close_link
End Select
End Sub
代码错了吗?
...全文
246 8 打赏 收藏 转发到动态 举报
写回复
用AI写文章
8 条回复
切换为时间正序
请发表友善的回复…
发表回复
jjs008 2004-04-30
  • 打赏
  • 举报
回复
呵呵,看程序看晕了没看到
warlord 2004-04-30
  • 打赏
  • 举报
回复
一眼就看出来了,单调也能找到啊。
VBDN 2004-04-30
  • 打赏
  • 举报
回复
SaySorry说得对,IF语句没有合口。
ryuginka 2004-04-30
  • 打赏
  • 举报
回复
要学会更总执行调试程序啊.
flc 2004-04-30
  • 打赏
  • 举报
回复
呵呵
SaySorry 2004-04-30
  • 打赏
  • 举报
回复
If myTempRow = 0 Then
Else
If fRow <= myTempRow Then
Grid1.TextMatrix(fRow, 0) = ""
End If
fRow = myTempRow
Grid1.TextMatrix(fRow, 0) = "*"

Call close_link
End Select
End Sub

少了一个end if而已
vlsm 2004-04-29
  • 打赏
  • 举报
回复
程序中途跳出去了
northwolves 2004-04-29
  • 打赏
  • 举报
回复
如果就一种CHOICE,没必要添加此参数:

Public Sub Grid_Delete(ByVal grid As MSHFlexGrid, ByVal choice As Integer)
Select Case choice
Case 1
Dim Msg As String
Dim strSQL As String
Dim myTempRow As Integer
Call check_link

If fRow = 0 Then
MsgBox "请选择要修改的行!", vbOKOnly + vbInformation, "注意"
Exit Sub
End If
Msg = MsgBox("确定删除当前纪录吗?", vbYesNo + vbInformation)
If Msg = vbNo Then
Exit Sub
End If

'删除当前记录
strSQL = "DELETE * FROM Customer WHERE ORDERN='" & Grid1.TextMatrix(fRow, 0) & "'"

fCnn.Execute strSQL


If Grid1.Rows = 2 Then
Grid1.Rows = 1
Else
Grid1.RemoveItem fRow
End If
myTempRow = Grid1.Rows - 1
If myTempRow = 0 Then
Else
If fRow <= myTempRow Then
Grid1.TextMatrix(fRow, 0) = ""
End If
End if'----------------------------------------->ADD THIS LINE
fRow = myTempRow
Grid1.TextMatrix(fRow, 0) = "*"

Call close_link
End Select
End Sub

7,763

社区成员

发帖
与我相关
我的任务
社区描述
VB 基础类
社区管理员
  • VB基础类社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧