主题：奇怪现象

有产品表、客户表、订单表

产品表字段：产品ID,产品名称

客户表字段：客户ID，客户名称

订单表字段：产品ID，客户ID，数量，单价，折扣，日期

BeforeLoadOuterTable事件

For Each dt As DataTable In DataTables
     e.SelectString="select * from {" & e.DataTablename & "} where [_Identify] Is Null"
Next

AfterOpenProject

For Each dt As DataTable In DataTables
    With dt
        .LoadFilter = ""
        .LoadTop = 20
        .LoadPage = 0
        .Load()
    End With
Next

反复打开项目会发现订单表的产品ID，客户ID有时有数据，有时没数据，有时还正常怎么回事？

补充：订单表的产品ID、客户ID用了数据字典，数据来自产品表、客户表。

补充：将BeforeLoadOuterTable事件下的遍历去掉，否则打开项目时会出错。

只保留 e.SelectString="select * from {" & e.DataTablename & "} where [_Identify] Is Null"

BeforeLoadOuterTable事件

For Each dt As DataTable In DataTables
     e.SelectString="select * from {" & e.DataTablename & "} where [_Identify] Is Null"
Next

 

 

改为：

 

e.SelectString="select * from {" & e.DataTablename & "} where [_Identify] Is Null"

OK