以文本方式查看主题

-  Foxtable(狐表)  (http://foxtable.com/bbs/index.asp)
--  专家坐堂  (http://foxtable.com/bbs/list.asp?boardid=2)
----  sqltable删除  (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=100205)
--  作者：114039247
--  发布时间：2017/5/6 18:22:00
--  sqltable删除
删除sqltable表选中的行包括后台对应的行数据
--  作者：有点色
--  发布时间：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(",") & ")")