主题：[求助] 表

谢谢，账套在服务器上，连接外部数据库后，可不可以不下载这三个表到foxtable中，直接做查询出来呢？

编辑查询表，点击预览，把sql复制出来使用：http://www.foxtable.com/webhelp/scr/0696.htm

 

版主以下有错吗？怎么按了后没有反应的。

 

Dim  cmd As New SQLCommand
cmd.C

 

Dim  cmd As New SQLCommand
cmd.C

 

代码为什么发不上来？

只能用图了

此主题相关图片如下：捕获.png

http://www.foxtable.com/webhelp/scr/0696.htm

版主，不好意思，帮忙再看一下，有点不对，谢谢。

 

Dim Cols1() As String = {"FBillNo","FClosed","FName","FQty","FNumber","FPrice"}
Dim Cols2() As String = {"FBillNo","FClosed","FName","FQty","FNumber","FPrice"}
For Each dr1 As DataRow In DataTables("SEOrderEntry")
     Dim dr2 As DataRow = DataTables("表D").AddNew()
     For i As Integer = 0 To Cols1.Length -1
         dr2(Cols2(i)) = dr1(Cols1(i))
     Next
 Next

有什么不对，什么错误？