以文本方式查看主题

-  Foxtable(狐表)  (http://www.foxtable.com/bbs/index.asp)
--  专家坐堂  (http://www.foxtable.com/bbs/list.asp?boardid=2)
----  [求助]窗口中用Fill方法生成的查询表如何修改列名  (http://www.foxtable.com/bbs/dispbbs.asp?boardid=2&id=153349)

--  作者:huangfanzi
--  发布时间:2020/8/7 18:14:00
--  [求助]窗口中用Fill方法生成的查询表如何修改列名
t.Fill("s elect " & zd & " From {合同} As a Where " & flt & " ORDER BY 类别,合同关联编号,合同关联序号" ,"ShcsErpSql",True)
t.Cols("昨日行情").Caption = Date.Today.AddDays(-1) & "行情"
窗口中得到表后,我想把昨日行情这个列名改下,可这行代码不生效,应该如何写
谢谢

--  作者:有点蓝
--  发布时间:2020/8/8 8:23:00
--  
t.Fill("s elect " & zd & " From {合同} As a Where " & flt & " ORDER BY 类别,合同关联编号,合同关联序号" ,"ShcsErpSql",True)
With t.DataTable
    .DataCols(
"昨日行情").Caption = Date.Today.AddDays(-1) & "行情"
    .BuildHeader()

End
 With