RSView32利用VBA实现报警历史查询  

Implement of VBA Alarm History Inquiry by Using of RSView32

作　　者：宋勇江[1] 巩伟[1] 

机构地区：[1]黑龙江省科学院自动化研究所,黑龙江哈尔滨150090

出　　处：《自动化技术与应用》2014年第4期85-87,94,共4页Techniques of Automation and Applications

摘　　要：针对RSVIEW32组态软件只生成历史数据库不具备查询功能的特点,通过分析软件生成数据库的内部结构,通过ADO数据引擎读取其中的数据,结合RSVIEW32软件集成的VBA功能,开发VBA数据库处理程序,完成了对历史报警数据提取,历史操作记录的查询功能,并能生成统计报表,满足用户对事故追忆、生产统计信息的针对性查看的要求。Aiming at the characteristic that RSVIEW32 configuration Software to generate only historical database,does not have the inquiry function,this article through the analysis of internal structure of software to generate the database,by using of ADO data engine to read the data,combining VBA function of RSVIEW32 software integration,develops manage procedure of VBA datage,completes the drawing of historical alarm data inquiries,the historical operation record generates statistics report,meets the requirement of accident recall for users and inquiry of production statistics information.

关 键 词：RSVIEW32 VBA 组态软件 ADO 数据库 

分 类 号：TP277.1[自动化与计算机技术—检测技术与自动化装置]