Wang Qinghua

Extended Application of Visual FoxPro 9.0 Database Management System to Tobacco Smoke Analysis

To improve the accuracy and efficiency of data processing in the process of tobacco smoke analysis,a data acquisition and management system was developed based on Visual FoxPro 9.0 database management system, wherein RS232 serial interface communication technology was used to connect PC with a number of smoking machines and perform remote control of and data acquisition from RM200 smoking machines, and Ethernet communication technology was used to remotely access and collect data from RM200A smoking machines and gas chromatograph. By programming data management module, the management and application of test data, process data and product information were carried out. The results of application in tobacco smoke analysis laboratory showed that the developed management system could collect test data from smoking machines and gas chromatograph of different types and converge process data on the VFP database platform,and the data processing flow was fully programmed and standardized. Possible errors caused by manual operations were avoided, work efficiency and the accuracy of test report were improved.