Rss & SiteMap
Foxtable(狐表) http://www.foxtable.com
父表与子表同步加载,父表加载后,两个子表的数据没有加载完是怎么回事呢,只加载了一部分,用的sql
请教下这个是怎么回事呢,谢谢!
If DataTables("销售订单").DataRows.Count = 0 Then '如果订单表没有数据
DataTables("销售明细").LoadFilter = "订单编号 Is Null" '不加载订单明细
Else
Dim ids As String
For Each dr As DataRow In DataTables("销售订单").DataRows
ids = ids & "," & dr("订单编号")
Next
ids= ids.Trim(",")
DataTables("销售明细").LoadFilter = "订单编号 In (" & ids & ")"
DataTables("销售出库").LoadFilter = "订单编号 In (" & ids & ")"
End If
DataTables("销售明细").Load()
DataTables("销售出库").Load()