omron — Advanced dialog

Data Logging and Display When Data Source (in the Grid Object Properties dialog ) is set to Text File or Class Tag, the Column is the value specified in the Label. When Data Sourse is set to Database, the column is the value specified in the Field. (In this case, if the Field is left blank, then the column value specified is the Label.) Also, expressions for Database must be formatted like a SQL Where statement. The following table shows which operators should be used: Condition Expression Operators As such, the following expression for Text File… C1 = 'ab?d' …means the same as the following expression for Database…

C1 LIKE 'ab_d' Finally, you can combine several expressions simultaneously in the Condition field, using the logic operators AND , OR , and NOT . For example: ColumnAge > '10' OR ColumnName = 'John' AND ColumnDate > '05/20/2003' Tip: You can configure tags between curly brackets {TagName} in the Condition field to change the filtering condition during runtime. • Print Trigger : When the tag configured in this field is toggled, the current state of the Grid object is sent to the default printer. • PDF Trigger field: When the tag configured in this field is toggled, the current state of the Grid object is saved as a PDF file at the location specified by PDF Filename . • PDF Filename field:

Enter a complete file path and name where the PDF file is to be saved. You can also enter a tag name using the {tag} syntax. Note: PDF Trigger and PDF Filename are not supported in projects running on Windows Embedded or Thin Client. • Multiline checkbox: When this option is checked, the print output or PDF will be formatted according to the available column space, and the text within each cell will be wrapped so that all of it is shown. • Reload : When the tag configured in this field is toggled, the object reloads the data from the data source and displays it. • Save Trigger :

When the tag configured in this field is toggled, the data source (Text File or Database) is updated with the current values of the grid object. This field is not available when the Data Source type is Class Tag, because the values are automatically updated in the tags as you change a cell in the grid. • Insert Trigger : When Auto refresh after insert trigger is enabled (checked), the tag configured in this field is used as a trigger to refresh the database table. Whenever the value of the tag changes, a new row is added to the table and the values of the array configured in the Inserted Values field are automatically inserted. • Inserted Values :

If the Insert Trigger is being used, then the array tag configured in this field provides the values that will be inserted. This field must only contain an array tag, although it can be of any size. • Save on data change : When this option is checked, the values are updated on the data source (Text File or Database) as soon as the user enters a new value on the grid, during runtime. This option is disabled when the Data Source type is Class Tag, because the values are automatically updated in the tags as the user changes the value of the cells in the grid. • Enable Slider/Resize :

If this box is not checked, the user is unable to scroll the list by dragging the slider button, or to change the cell's size during runtime. Page 268 InduSoft Web Studio Comparison Data Source is Text File… Data Source is Database… equal to = LIKE not equal to NOT LIKE wildcard, single character ? _ wildcard, unlimited characters * %