主题：请教甜老师（已上传项目）

 查找，赋值

http://www.foxtable.com/help/topics/0396.htm

 不会做，就上传具体例子

 afterload，代码

'过滤出供方确认到货时间为空,且已批准为true的记录
Dim t As Table = e.Form.Controls("Table1").Table
t.Fill("select *, orderSupDhTime as 确认到货日期, orderYpz as 已批准 from {orderlist} where orderSupDhTime Is null And orderYpz = true", False)

table控件，设置成sqlTable类型

查找，赋值

http://www.foxtable.com/help/topics/0396.htm

 afterload事件代码啊

Dim t As Table = e.Form.Controls("Table1").Table
t.Fill("select *, orderSupDhTime as 确认到货日期, orderYpz as 已批准 from {orderlist} where orderSupDhTime Is null And orderYpz = true", False)

 关键代码是这段

select orderSupDhTime as 确认到货日期, orderYpz as 已批准 from {orderlist} where orderSupDhTime Is null And orderYpz = true

 加上.Table就转成Table类型了

 解释正确；不加上，就是Table控件，不是Table类型

 你要显示多少个字段，就写多少个即可啊

orderSupDhTime as 确认到货日期, orderYpz as 已批准

呃。。。

Dim t As Table = e.Form.Controls("Table1").Table
t.Fill("select orderSupDhTime as 确认到货日期, orderYpz as 已批准 from {orderlist} where orderSupDhTime Is null And orderYpz = true", False)