窗口表类型为SQLQuery,SQL如下:
s elect
Measurements.DateTime_ as '检验日期',
Measurements.ID1 as '炉号',
rtrim(YangPin.name) as '样品分类',
Results.Component as '成分',
Results.Reported as '值'
fr om Measurements
left join Results on Results.Measurement=Measurements.id
left join YangPin on YangPin.id=Measurements.id3
where Measurements.id is null
order by Measurements.ID
在窗口中添加按钮、和文本框架,实现窗口表按条件查询数据:
Dim bh As WinForm.TextBox = e.Form.Controls("TextBox1")
Tables("窗口1_Table1").DataTable.LoadFilter = "炉号 = " & bh.Text
Tables("窗口1_Table1").DataTable.Load
报错,求助