Settings and queries for IFix alarm history

Thread Content

In practical engineering, data changes such as digital signal variations and analog signal out-of-range conditions need to be stored in a historical database, which is referred to as an alarm history database; thereafter, programs are written to retrieve this alarm history. How can alarms be stored in the alarm history database? Using ACCESS as the alarm history database, the implementation process of such a database will be illustrated. Step 1: Create a database of the ACCESS type named hisdata, with the path D:\Dynamics\SampleSystem\HistoricalData. Both the name and path can be defined by yourself, with no restrictions. Step 2: Create a DSN in the ODBC Data Manager, name it hisdata, and then select the driver for installing the data source, namely Driver Microsoft Access(*mdb). Step 3: Choose the Driver Microsoft Access (*.mdb) option, click Finish, enter the data source name as hisdata, and provide a description such as “IFIX Alarm History Database”. Step 4: Open the system configuration of iFIX3.5, start the ALARM ODBC SERVER, and carry out the configurations – select the database type, database identifier, configure the list, and fill in the relevant descriptions. Step 5: Create a new form named “Historical Alarms”. Add 4 DTPicker controls to this form (DTPFromDate, DTPFromTime, DTPToDate, DTPToEndTime), 2 Text controls, 1 CommandButton control (cmdOK), 1 VXGrid control (VXGrid1), and 1 VXData control (VXData1). The VXGrid control is used to display the query results, the DTPicker controls are used to select the start and end times, and the CommandButton control is used to initiate the query. The VXdate control is used to connect to the database