主题：[求助] 表

版主，在foxtable中外连数据库后，如何连续金蝶的销售订单表。谢谢。

 

你连上金蝶的数据库了没有？

 

连上后，参考

 

http://www.foxtable.com/bbs/dispbbs.asp?BoardID=2&ID=101661&skin=0

 

 

版主，连接上了。现在我只想在窗口中增加个按钮，就能把销售订单中还没有关闭的订单明细增加到表A 中。这个代码是怎样的？

数据填充参考：http://www.foxtable.com/webhelp/scr/1533.htm

版主， 这是从Excel表中导入到foxtable

Dim Book As New XLS.Book("Z:\GSS Shanghai\Planning\Order handling\order control List.xlsx")
Dim Sheet As XLS.Sheet = Book.Sheets(0)

DataTables("Orderlist").datarows.clear

Tables("Orderlist").StopRedraw()
Dim nms() As String = {"Orderdate","Customer","GSSAG_PO","EndCustomer","CustomerPO","Pos","IndexNo","GSSPart","PartNo","OrderQty","OpenQty","UnitPrice","OrderVolume","Currency","RequestETA","ConfirmedETA","ETA","PickupDate","ETD","ShippingTerms","SupplierOrder","SupplierDate","SupplierName","Stock","Status","DeliveryAddress","SupplierPrice","Totalcost","GrossProfit","ProfitMargin","UnitWeight","TotalWeight","Assemblyhours","TotalAssemblyhours","Barcode"}

 

For n As Integer = 2 To Sheet.Rows.Count -1
    Dim r As Row = Tables("Orderlist").AddNew()
    For m As Integer = 0 To nms.Length - 1
         r(nms(m)) = Sheet(n,m).Value
    Next

Next
Tables("Orderlist").ResumeRedraw()
DataTables.save

可是要将Sql的数据库中的 SEOrder and SEOrderEntry 中相关列导入到Foxtable中还是不了解了。能指导 一下吗？ 这个账套路径是 在z:\

 

连接sql数据源、把这个表加入外部表管理：http://www.foxtable.com/webhelp/scr/1812.htm

老师，你好，

 

如图，我把金蝶账套中的相关表增加进来了。这些都是明细。能不能不要这些明细，我在窗口中增加了一个按钮，只要一按，就把订单号，产品代码，规格型号，数量，交货期直接导入到表D中，其它表都不需，可以吗？ 麻烦了。

1、不知道你需要哪些表的哪些列的数据；

 

2、能否做一个实例发上来测试？