Advanced dialog

Use the Advanced dialog box to configure the advanced settings for a Grid object.

User Enable

If the value of this tag is TRUE (different from 0), the user can select different rows of the object by clicking on them during run time. This box can be configured with a tag or with a numeric value.

Selected Values

The values from each column of the selected row are written to each position of the array tag configured in this box. Moreover, you can modify the value of the cells currently selected in the Grid object by changing the value of array tag configured in this box. The initial array position (offset) can be configured in this box.

Number of Rows

The Grid object writes the number of rows currently available in the Grid object to the tag configured in this box.

Row Number

The Grid object writes the number of the row currently selected during run time. In addition, you can select different rows by writing their values in this tag.

Condition

Enter an expression to filter the grid data; only rows that match the expression will be displayed. The expression must use the following syntax:

[Column] Operator Value

For example…

[ColumnX] > 200

When Data Source (in the Grid Object Properties dialog box) is set to Text File or Class Tag, the Column is the value specified in the Label. When Data Source 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

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 box, using the logic operators AND, OR, and NOT. For example:

[ColumnAge] > '10' OR [ColumnName] = 'John' AND [ColumnDate] > '05/20/2003'

If you have configured multiple columns to contain date/time values but each column is of a different type (that is, a different time zone), the filter will convert the values in all of the columns to match the type of the last column. For example, if columns 2 and 3 are configured as Date/Time but column 4 is configured as Date/Time - UTC, the values in columns 2 and 3 will be converted to UTC for the purposes of filtering.

This field accepts String expressions.

Print Trigger

When the tag configured in this box is toggled, the current state of the Grid object is sent to the default printer.

PDF Trigger

When the tag configured in this box is toggled, the current state of the Grid object is saved as a PDF file at the location specified by PDF Filename.

PDF Filename

Enter a complete file path and name where the PDF file is to be saved. This field accepts String expressions.

PDF Trigger and PDF Filename are not supported in projects running on Windows Embedded or Thin Client.

Multiline

When this option is selected, 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 box is toggled, the object reloads the data from the data source and displays it.

Save Trigger

When the tag configured in this box is toggled, the data source (Text File or Database) is updated with the current values of the Grid object. (This box 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 the Auto refresh after insert trigger option is selected, the tag configured in this box 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 box are automatically inserted.

Inserted Values

If the Insert Trigger is being used, then the array tag configured in this box provides the values that will be inserted. This box must only contain an array tag, although it can be of any size.

Save on data change

When this option is selected, the values are updated on the data source (Text File or Database) as soon as the user enters new values in the grid during run time.

This option is disabled in the following situations:

• When the Data Source type is Class Tag, because saving on data change is the default behavior for that type of data source; and

• When the Data Source type is Database and a redundant database is configured, because the Grid object can write to only one database at a time. For more information, see Database Configuration.

  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 run time.

  Conditional check-box

  When this option is selected, the user cannot check a checkbox on the Grid during run time, unless all preceding checkboxes in the same column are also checked. This option is especially useful when you want to oblige the user to follow a pre-defined sequence. This box is not available when the Data Source type is Class Tag.

  Show Header

  When this option is selected, the header of the Grid object is visible during run time, displaying the label of each column.

  Show gridlines

  When this option is selected, the gridlines of the Grid object are visible during run time.

  Enable translation

  When this option is selected, the text displayed by the Grid object will be subject to translation by the Translation Tool during run time.

  This does not include columns which have been configured to accept user input (that is, for which the Input option in the Columns dialog box has been selected).

  Disable TAB to navigate through cells

  When this option is selected, the user can only navigate through the cells of the Grid Object with the arrow keys, rather than the Tab key. You should disable the Tab key for navigation if you want it to be used for switching to the next object that supports focus on the screen.

  Auto refresh after insert trigger

  See Insert Trigger above.

  Concatenate Label for Picture

  When this option is selected, the reference name for the picture is the result of the concatenation of the name in the Field column with the value of the Label column. The result will be <Label name>_<Field value>.

  Export

  This interface allows you to export the data from the Grid object to a class-array tag, regardless of the Data Source selected for the object. The following settings must be configured to support this feature:

  Setting	Description
  Class tag	Type the main tag name of the class-array tag that will receive the exported values. Each row from the Grid object will be exported to one array position of the array tag, by matching column labels. The initial array position can be configured in this box; 0 is the default.
  Trigger	When the tag configured in this box changes value (for example, toggles), the data is exported from the Grid object to the class-array tag configured in the Class tag field.

  After you export the data to tags, you can use different functions and tasks to manipulate the data.

  Auto Format

  When this option is selected, decimal values in columns of Numeric type will be formatted according to the virtual table created by the SetDecimalPoints function. This option will work only in columns for which Decimal Points are not already configured. For more information, please see Columns dialog.