我想从画面设定数据库的查询起始时间,在画面建了6个IO域,分别连了六个内部变量a,b,c,d,e,f,类型为有符号32位数,分别对应对应年月日时分秒,运行的时候改变起始时间,但输出的结果都是一样的,起始时间没用改变,怎么回事啊?怎么在画面上设定查询时间啊?控件用的是LISTVIEW.
补充:时区已经考虑在内,直接用的是格林威治时间。
程序的一部分
sPro = "Provider=WinCCOLEDBProvider.1;"
sDsn = "Catalog=CC_ss_09_12_30_08_48_57R;"
sSer = "Data Source=.\WinCC"
sCon = sPro + sDsn + sSer
bday="a+'-'+b+'-'+c"
btime="d+':'+e+':'+f"
bb="bday+' '+btime"
sSql = "TAG:R,'m\Tag1','bb' ,'2009-12-29 1:38:19'"
'sSql = "TAG:R,'m\Tag1','2009-12-29 1:21:19' ,'2009-12-29 1:31:19'"在这就可以改。
Set conn = CreateObject("ADODB.Connection")
conn.ConnectionString = sCon
conn.CursorLocation = 3
conn.Open
Set oRs = CreateObject("ADODB.Recordset")
Set oRs = CreateObject("ADODB.Recordset")
Set oCom = CreateObject("ADODB.Command")
oCom.CommandType = 1
Set oCom.ActiveConnection = conn
oCom.CommandText = sSql
Set oRs = oCom.Execute