omron — Database/ERP worksheet

Background Tasks Other settings to configure, if necessary: • Disable Primary Keys checkbox: 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 check this box. • Disable Milliseconds in Date/Time Columns checkbox: IWS will try to include milliseconds when saving a date/time in the database. If you are using a database that does not support milliseconds, then you should check this box. 8. Click OK to close the dialog and save the connection configuration. Database connections are saved as XML files in the \ project_name \Config sub-folder.

Each file is given the same name as the name of the connection (as entered in the Name field of the Database Connection dialog), with the .XDC file extension. For example, the connection configuration DB1 is saved in the file… \ project_name \Config\DB1.XDC Database Worksheet Note: This feature emulates Structured Query Language (SQL) database operations. You should be familiar with how SQL commands are formed and executed before you use this feature. Database worksheets allow asynchronous execution of database operations, and they offer a user- friendly interface for building SQL commands. Use one of the following methods to create a new database worksheet:

• On the Insert tab of the ribbon, in the Task Worksheets group, click Database ; or • Right-click on the Database/ERP folder in the Project Explorer, and then click Insert on the shortcut menu; or A new worksheet is displayed, as shown below: Database worksheet Database worksheets are saved in the \ project_name \Config directory, with the .XDB file extension. Each new worksheet is automatically numbered in the order of its creation. For example, the first worksheet created is saved in the file… \ project_name \Config\DB001.XDB Database worksheets are executed under the Database Client Runtime task.

However, creating a new worksheet does not automatically enable the task; you must use the Execution Tasks dialog ( Tasks on the Home tab of the ribbon) to configure the task to start at runtime. For more information, please see Execution Tasks . Also, database worksheets run only on the server, and all triggers must be configured with server tags. Worksheet Header The header of the database worksheet is configured as follows: • Description field: Enter a description of the worksheet, for documentation purposes. • Status field: Enter the name of a numeric tag that will receive status codes for database operations during runtime: InduSoft Web Studio Page 287