Working with SBM Database Fields

There are two types of fields in the database depending on the type of table you are working with:

• System table: System tables are automatically created for every SBM database and are used by SBM internally. System table fields cannot be renamed.

  When writing scripts where you specify field names for system tables, enter the name entirely in lowercase characters (without the TS_ prefix) or the field will not be found.

• All other tables: Non-system tables, such as primary or auxiliary tables, include system fields that are automatically added to every table, as well as fields that are added by users. Both types of fields are considered variable fields, which can be renamed.

  Field names for variable fields should be provided in uppercase characters for database column names characters (without the TS_ prefix) or in lowercase or mixed case characters for display names (for Title, for example).

Keep this distinction in mind as you work with functions that require you to specify field names (such as GetFieldValue and SetFieldValue).