Foxtable(狐表)用户栏目专家坐堂 → [求助]FOR .....NEXT


  共有21248人关注过本帖平板打印复制链接

主题:[求助]FOR .....NEXT

帅哥哟,离线,有人找我吗?
狐哥
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:三尾狐 帖子:719 积分:5181 威望:0 精华:1 注册:2008/9/24 10:41:00
[求助]FOR .....NEXT  发帖心情 Post By:2009/3/14 10:11:00 [只看该作者]

哪位老师帮我修改一下如下循环公式,第一行变动时总是提示错,点确认后下一行又出错,不能循环.


For Each sjmxdr As dataRow In datatables("收据明细").dataRows
    if sjmxdr isnot nothing then
        Select Case e.DataCol.Name
        Case "币制"
            Dim zsdrs As List(Of datarow) = DataTables("折算表").select("[币制] = '" & sjmxdr("币制") & "' and [折算币制] = '" & sjmxdr("收据币制") & "'")
            For Each zsdr As datarow In zsdrs
                if zsdr isnot nothing then
                    sjmxdr("折算符") = zsdr("折算符")
                    sjmxdr("兑换率") = zsdr("汇率")
                end if
            Next
        case "兑换率","收据币制"
            Dim s As String = sjmxdr("金额") & sjmxdr("折算符") & sjmxdr("兑换率")
            sjmxdr("收据金额") = eval(s)
        case "收据金额"
            dim sjdr as datarow = tables("收据").Current.DataRow
            If sjdr IsNot Nothing Then
                dataTables("收据").dataCols("折合币制").RaiseDataColChanged(sjdr)
            End If
    end select
end if
next

 回到顶部