回复:wincc6.0 用vbs读写acess数据问题

万泉河

  • 帖子

    10900
  • 精华

    132
  • 被关注

    1008

论坛等级:至圣

注册时间:2003-06-06

钻石 钻石 如何晋级?

发布于 2006-01-24 15:37:57

0楼

下面是SP3的自动向导生成的范例程序,请参考:
Sub Change(ByVal Item)
Dim txtDateTimeFrom
Dim txtDateTimeTo
Set txtDateTimeFrom = ScreenItems("txtDateTimeFrom")
Set txtDateTimeTo = ScreenItems("txtDateTimeTo")
Dim strDateTimeFrom
Dim strDateTimeTo
Dim objDateTimeHelper
Set objDateTimeHelper = CreateObject("CCDataConnector.clsDateTimeHelper")
objDateTimeHelper.GetAbsoluteIntervalFromRelative CStr(txtDateTimeFrom.Text),CInt(-1),CStr(txtDateTimeTo.Text),strDateTimeFrom,strDateTimeTo
Set objDateTimeHelper = Nothing

Dim objTag
Set objTag = ScreenItems("cmbTag")
Dim Adodc1
Set Adodc1 = ScreenItems("Adodc1")
Adodc1.RecordSource="Tag:R,'" & objTag.Text & "','" & strDateTimeFrom & "','" & strDateTimeTo & "'"
Adodc1.Refresh
Dim objDataGrid1
Set objDataGrid1 = ScreenItems("DataGrid1")

objDataGrid1.Clear
objDataGrid1.FixedCols = 1
objDataGrid1.FixedRows = 1
objDataGrid1.ColHeader(0) = 0
objDataGrid1.AllowUserResizing = 1
objDataGrid1.Redraw = False
objDataGrid1.ColWidth(0) = 250
objDataGrid1.ColWidth(2) = 3075
objDataGrid1.ColWidth(3) = 2115
objDataGrid1.ColWidth(4) = 1365

Set objDataGrid1.DataSource = Adodc1.Recordset
objDataGrid1.Row=0
objDataGrid1.Col=1
objDataGrid1.Text="TagID"
objDataGrid1.Col=2
objDataGrid1.Text="Date/Time"
objDataGrid1.Col=3
objDataGrid1.Text="Value"
objDataGrid1.Col=4
objDataGrid1.Text="Quality code"
objDataGrid1.ColWidth(5)=0
objDataGrid1.Col=1
objDataGrid1.Row=1
objDataGrid1.Redraw = True


End Sub
微信公众号:PLC标准化编程,ZHO6371995
评论
编辑推荐: 关闭

请填写推广理由:

本版热门话题

SIMATIC WinCC / Panel

共有32564条技术帖

相关推荐

热门标签

相关帖子推荐

guzhang

恭喜,你发布的帖子

评为精华帖!

快扫描右侧二维码晒一晒吧!

再发帖或跟帖交流2条,就能晋升VIP啦!开启更多专属权限!

  • 分享

  • 只看
    楼主

top
您收到0封站内信:
×
×
信息提示
很抱歉!您所访问的页面不存在,或网址发生了变化,请稍后再试。