Configure the Properties on the Data Set Form

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

The Data Set Form comprises these tabs:

• Identification—Use to configure the Identification details (see Defining Identification Details).
• User Methods—Use to define any custom pick actions (‘methods’) for the Data Set (see Using the User Methods Tab to Define Custom Actions).
• Data Set—Use to specify these properties:
  • Table Name—Enter a unique name for the Data Set, as you want it to appear in the ClearSCADA database. The name is used to identify the table when configuring, for example, the SQL or Logic that is to automatically populate the Table with data.

    The Table 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.

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

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

  • Title—Enter the title that is to be displayed in the header whenever operators display the Grid’s data as a List. The Title can include character spaces.