Foxtable(狐表)用户栏目专家坐堂 → 连续编号,提取中间缺少的号码


  共有2312人关注过本帖树形打印复制链接

主题:连续编号,提取中间缺少的号码

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


加好友 发短信
等级:版主 帖子:85326 积分:427815 威望:0 精华:5 注册:2012/10/18 22:13:00
  发帖心情 Post By:2018/1/5 15:20:00 [显示全部帖子]

Dim t1 As Table = Tables("表A")
Dim t2 As Table = Tables("表B")
For i As Integer = 1 To t1.Rows.count-1
    Dim r1 As Row = t1.Rows(i-1)
    Dim r2 As Row = t1.Rows(i)
    If r2.IsNull("第一列") = False Then
        If r1("第一列") + 1 <> r2("第一列") Then
            For j As Integer = r1("第一列")+1 To r2("第一列")-1
                Dim idx = t2.findrow("第一列 is null")
                Dim nr As Row
                If idx < 0 Then
                    nr = t2.addnew
                Else
                    nr = t2.Rows(idx)
                End If
                nr("第一列") = j
            Next
        End If
    End If
Next

 回到顶部