Configure the Properties on the Data Grid Form

To configure the properties on the Data Grid Form, you need to display the Form (see Display a Form).

You can also display the Data Grid Form from the Queries Bar. To do this:

1. Display the Queries Bar (see Display an Explorer Bar in the ClearSCADA Guide to ViewX and WebX Clients).
2. Expand the Data Grids branch of the Queries Bar.
3. Right-click on the required Data Grid entry.
   A context-sensitive menu is displayed.
4. Select the Edit Properties option from the menu to display the Data Grid Form.

The Data Grid Form has these tabs:

• Identification—Use to configure the Identification properties (see Defining Identification Details).
• User Methods—Use to define any custom pick actions (‘methods’) for the Data Grid (see Using the User Methods Tab to Define Custom Actions).
• Data Grid—Use to define the Table name and Title:
  • Table Name—Enter a unique name for the Data Grid table, as you want it to appear in the ClearSCADA database.

    The name has to begin with an alphabetical character and contain only alphanumeric characters (see Naming Restrictions). The maximum name length that you can specify is 23 characters.

    Although we do not recommend its use in table or database names (see below), the underscore character ( _ ) is also a legal character.

    NOTICE

    UNEXPECTED BEHAVIOR OF APPLICATION

    Avoid using the underscore character ( _ ) in names of database items. The underscore character is treated as a 'wildcard' for a single character in SQL unless it is escaped in the query. If queries are run on database item Names or FullNames on large systems in which names contain underscore characters (and the underscore characters are not escaped in the query), this could significantly impact on CPU usage while the query runs.

    Failure to follow these instructions can result in a significant impact on CPU usage when running SQL queries on large systems.

    Ensure that the Table Name is not identical to that of any built-in table, other Data Grid table, or any other ‘custom’ tables, including Historic Views.

    We advise that Table Names do not start with the letter ‘C’, to avoid confusion with built-in tables.

  • Title—Enter a unique title for the Data Grid. This is the title of the Data Grid when it is displayed in List format. The title can include character spaces.