| RSView32利用VBA实现报警历史查询 |
| |
| 引用本文： | 宋勇江,巩伟.RSView32利用VBA实现报警历史查询[J].自动化技术与应用,2014(4):85-87,94. |
| |
| 作者姓名： | 宋勇江 巩伟 |
| |
| 作者单位： | 黑龙江省科学院自动化研究所,黑龙江哈尔滨150090 |
| |
| 摘 要： | 针对RSVIEW32组态软件只生成历史数据库不具备查询功能的特点,通过分析软件生成数据库的内部结构,通过ADO数据引擎读取其中的数据,结合RSVIEW32软件集成的VBA功能,开发VBA数据库处理程序,完成了对历史报警数据提取,历史操作记录的查询功能,并能生成统计报表,满足用户对事故追忆、生产统计信息的针对性查看的要求.
|
| 关 键 词： | RSVIEW32 VBA 组态软件 ADO 数据库 |
Implement of VBA Alarm History Inquiry by Using of RSView32 |
| |
| SONG Yong-jiang,GONG Wei.Implement of VBA Alarm History Inquiry by Using of RSView32[J].Techniques of Automation and Applications,2014(4):85-87,94. |
| |
| Authors: | SONG Yong-jiang GONG Wei |
| |
| Affiliation: | 1.Automation Institute of Heilongjiang Academy of scinces, Harbin 150090 China;) |
| |
| Abstract: | 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. |
| |
| Keywords: | RSVIEW32 VBA configuration software ADO database |
| 本文献已被 CNKI 维普 等数据库收录！ |
|
