陈寒清WINCC视频教程报表脚本-打开画面显示当天数据.docxVIP

SetoCom=CreatObiect(ADODBrCommand,F)-

□ConrkCoEmaridTite-1,L

Set0Com.ActiveConnetiononn.

oComi,CommandText=si,执行检索功能*■■

SetoRs=oCom.EKecute^

n=oRs.RecordCount获得检索到的总数,1

HMIRuntirn已Tag名(J3).W「itEn.

.

定义在线表格属性.

MSFIcxGridl.Clear

MSFIe^Grldl.Row莒=aRs.RecorefCount+2-

MSFlexGridl.CalWidth^)=700MSFIej(GridlolWidth{l}^IODO.

MSFkxGHdlolWidth(2)=3300.

,第一列宽度设置.

MSF^xGridl.ColWidth{31=2500-

MSF1exGridlolWidth(4)=2200-

MSHexGridirolWidth51=2950等6列施度设比方果列数多叫维续添力W

MSFlexGridl.RowHeight(0)=G00端一行高度设置.■

M