Foxtable(狐表)用户栏目专家坐堂 → 代码


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

主题:代码

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


加好友 发短信
等级:婴狐 帖子:75 积分:523 威望:0 精华:0 注册:2016/12/29 8:29:00
  发帖心情 Post By:2017/1/4 11:50:00 [只看该作者]

Dim num As Integer = 30
Dim tns() As String = {"庆前", "前列"}

For Each tn As String In tns
    Dim dt As DataTable = DataTables(tn)
    Dim q As new QueryBuilder
    q.TableName = "查询_" & tn

    Dim sql As String = ""
    For Each dc As DataCol In dt.DataCols
        If dt.Find(dc.name & " = '" & num & "'") IsNot Nothing Then
            sql &= "," & dc.name
        End If
    Next
    q.SelectString = "Select ,," & sql & " From {" & dt.Name & "}"

    q.Build
    MainTable = Tables(q.TableName)
Next

请问上述代码查询出来的行数出现了改变怎么办,我是要将含有“30”的列按照原来的顺序列到查询表中。


 回到顶部
总数 38 1 2 3 4 下一页