Foxtable(狐表)用户栏目专家坐堂 → sqltable删除


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

主题:sqltable删除

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


加好友 发短信
等级:超级版主 帖子:13837 积分:69650 威望:0 精华:0 注册:2016/11/1 14:42:00
  发帖心情 Post By:2017/5/7 15:01:00 [显示全部帖子]

Dim t As Table = Tables("表A")
Dim idxs As String = "-1,"
For i As Integer = t.TopPosition To t.BottomPosition
    idxs &= t.rows(i)("_Identify") & ","
Next
t.DataTable.RemoveFor("_Identify In (" & idxs.trim(",") & ")")
t.DataTable.sqlDeleteFor("[_Identify] In (" & idxs.trim(",") & ")")

 

 


 回到顶部