Creating a New Project See also: • SQL Relational Databases • Studio Database Gateway • Database Appendix A: Using ODBC Databases • Configuring a Default Database for All Task History CONFIGURING A DEFAULT DATABASE FOR ALL TASK HISTORY You can configure a Default Database that will save the historical data from all Tasks in a project. After you do, when you create a new Task worksheet, you can choose either to use the Default Database or to configure a new database for that specific worksheet. To configure the connection settings for the Default Database: 1. On the Project tab of the ribbon, in the Settings group, click Options . The Project Settings dialog is displayed. 2. Click Configure .
The Default Database Configuration dialog is displayed. Default Database Configuration dialog Please refer to Database Configuration dialog for help completing the fields in this window. Page 78 InduSoft Web Studio Proprietary SQL Relational Database Remarks File Vers. Field No. Field Name Field Type — Al Norm Time ms _ _ _ Number Number of milliseconds for the Norm Time timestamp. This field is used when the database does not support ms in a TimeStamp field. 003 — Al Ack Time ms _ _ _ Number Number of milliseconds for the Ack Time timestamp. This field is used when the database does not support ms in a TimeStamp field. 003 — Al Deleted _ Number Deleted, where: • 0:
Alarm message was not deleted by the user (not visible). • 1: Alarm message was deleted by the user (visible). 003 — Last Update _ Date/Time Timestamp of the last update for this event. 003 — Last Update ms _ _ Number Number of milliseconds for the Last Event timestamp. This field is used when the database does not support ms in a TimeStamp field. 003