Creating a New Project • Enable : Saves the milliseconds in the same field where the date is saved. • Separate Column : Saves the milliseconds in a separated column. In this case, the date is saved in one field (without the milliseconds precision) and the number of milliseconds is saved in a different column. This option is indicated where you want to save timestamps with the precision of milliseconds but the database that you are using does not support milliseconds for the Date fields. • Save time difference checkbox: When this option is checked (default), IWS saves the Time Zone configured in the computer where the project is running in each register of the database.
This option must be enabled to avoid problems with daylight savings time. • Database Gateway : Enter the Host Name/IP Address where the IWS Database Gateway will be running. The TCP Port number can also be specified, but if you are not using the default, you will have to configure the IWS Database Gateway with the same TCP Port. See the Studio Database Gateway section for information about how to configure the advanced settings for the IWS ADO Gateway. • Disable Primary Keys : For some modules, IWS will try to define a primary key to the table in order to speed up the queries.
If you are using a database that does not support primary keys (e.g., Microsoft Excel), then you should select (check) this option Table Pane This area allows you to configure the settings of the Table where the data will be saved. All tasks can share the same database. However, each task (Alarm, Events, Trend worksheets) must be linked to its own Table. IWS does not check for invalid configurations on this field, therefore you should make sure that the configuration is suitable for the database that you are using. • Use default name checkbox: When this option is checked (default), IWS saves and/or retrieves the data in the Table with the default name written in the Name field.
• Automatically create checkbox: When this option is checked (default), IWS creates a table with the name written in the Name field automatically. If this option is not checked, IWS does not create the table automatically. Therefore, it will not be able to save data in the database, unless you have configured a table with the name configured in the Name field manually in the database. • Name : Specifies the name of the Table from the database where the history data will be saved. Tip: To specify a sheet in a Microsoft Excel spreadsheet file, use the following syntax: [ sheetname $] • Refresh button:
If the database configured is currently available, you can press the Refresh button to populate the Name combo-box with the name of the tables currently available in the database. In this way, you can select the table where the history data should be saved instead of writing the Table name manually in the Name field. Run-Time Pane This area allows you set runtime values. The following fields are available: • Status (output) checkbox: The tag in this field will receive one of the following values: • Reload (output): Specify a reload tag if you are using curly brackets in any of the configuration fields.
When you want to reconnect to the database using the updated values on your tags, set the tag on this field to 1. IWS will update the configuration when trying to perform an action in the database, setting the tag back to 0 when it is finished. See also : Configuring a Default Database for All Task History . InduSoft Web Studio Page 81 Value Description 0 Disconnected from the database. The database is not available; your configuration is incorrect or it is an illegal operation. 1 The database is connected successfully. 2 The database is being synchronized.