quote:以下是引用臣臣在2009-04-09 15:47:43的发言:
使 winncc6.2的版本阿
我使用6.2版本,但是每次点击查询测试会跳出3个对话框,("&sqlriqijiu.Value&"%这个为设置的日期%)
"select avg(var1),avg(var2),avg(var3),avg(var4),avg(var5),avg(var6),avg(var7),avg(var8),avg(var9),avg(var10) from UA#DailyReport where riqijiu like '"&sqlriqijiu.Value&"%' and shijianjiu between 0 and 7 "
select shijianjiu,var1,var2,var3,var4,var5,var6,var7,var8,var9,var10 from UA#DailyReport where riqijiu like '"&sqlriqijiu.Value&"%' and shijianjiu between 16 and 23 order by shijianjiu"
select avg(var1),avg(var2),avg(var3),avg(var4),avg(var5),avg(var6),avg(var7),avg(var8),avg(var9),avg(var10) from UA#DailyReport where riqijiu like '"&sqlriqijiu.Value&"%' and shijianjiu between 16 and 23 "
我是用虚拟主机测试的,并且保证了一天24小时的数据,调整了24个整点!
打印前需要把布局里面的数据库连接改成当前,否则打印出来空表格目前不知道查询时怎么回事,希望高手赐教,另外一个疑问,难道每天打印需要重新连接数据库吗?这个文档高手不用看,新手看不懂!
当然,能出一个例子已经是西门子的进步,希望看到更详细的介绍和实例!