主题：提示列名无效

If kh.Text.Length>0 Then
    Filter="款号 = '" & kh.Text & "'"
End If

DataTables("库存调整入明细").LoadFilter = Filter
DataTables("库存调整入明细").Load
DataTables("库存调整出明细").LoadFilter = Filter
DataTables("库存调整出明细").Load
DataTables("销售明细").LoadFilter = Filter
DataTables("销售明细").Load
DataTables("采购退货单明细").LoadFilter = Filter
DataTables("采购退货单明细").Load
DataTables("采购收货单明细").LoadFilter = Filter
DataTables("采购收货单明细").Load
DataTables("直调出库单明细").LoadFilter = Filter
DataTables("直调出库单明细").Load
DataTables("直调入库单明细").LoadFilter = Filter
DataTables("直调入库单明细").Load
DataTables("盘点差异单明细").LoadFilter = Filter
DataTables("盘点差异单明细").Load

 

 

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

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

BeforeLoadInnerTable，BeforeLoadOuterTable事件有没有什么代码？

表事件，或者MainTableChanged这些项目事件有没有什么代码？

都没有

以上的表，全部都是查询表生成的

数据库是SQL2008R2

数据库表的列名不是款号，是不是要用SQL表里面的列名

这些都是查询表？查询表怎么生成的？设置窗口，或者sql发上来看看

top 0
[flow_no] As [单据编号],
[branch_name] As [仓库],
CONVERT(varchar(100),[oper_date], 111) as 日期,
{t_rm_saleflow}.[item_no] As [款号],
[item_name] As [品类],
[item_subname] As [品名],
[item_clsname] As [季节],
[color_name] As [花色],
[size_name] As [尺码],
[sale_qnty] As [数量],
[source_price] As [吊牌价],
round([sale_money],0) As [销售价],
[sell_way] As [销售类型码]
From {t_rm_saleflow}
Left JOIN {t_bd_branch_info} ON {t_bd_branch_info}.[branch_no] = {t_rm_saleflow}.[branch_no]
Left JOIN {t_bd_item_info} ON {t_bd_item_info}.[item_no] = {t_rm_saleflow}.[item_no]
Left JOIN [t_bd_item_cls] ON [t_bd_item_cls].[item_clsno] =
{t_bd_item_info}.[item_clsno]
Left JOIN [t_bd_color_code] ON [t_bd_color_code].[color_id] = substring(right({t_rm_saleflow}.[item_barcode],5),1,3)
Left JOIN [t_bd_size_code] ON [t_bd_size_code].[size_id] = right({t_rm_saleflow}.[item_barcode],2)
Where {t_rm_saleflow}.[branch_no] not in ('999901','999801','999601','000101','000601','000501','000401','000301','000201')

要用SQL表里面的列名，如果多个表都有item_no列，还要指定表名

查询表想要初值不加载数据 需要写在哪里

也是BeforeLoadOuterTable吗