Configure a database table

You can manually configure a database structure and populate it with NetLogic methods or using an OPC UA client.

Prerequisites

To configure a database table
  1. In Project view, select a Database object.
  2. In Properties, next to Tables, select Add to add a database table.
  3. Next to Columns, select Add to create a table column.
  4. (optional) To change the data type of the column value, next to Column#, select BaseDataType and select a different data type.
  5. Enter a Column# value or create a dynamic link.
  6. (optional) To change the column name. hover over Column#, select Edit, and enter a custom name.
  7. If you use an embedded database, set Record limit.

    • The minimum Record limit value is 1000.

    • The Record limit property only takes effect if there is at least one column in the table named Timestamp or Time and has the DateTime data type. The Timestamp or Time columns are automatically added to the table if you use a database to store data from a logger.

    At runtime, any records that exceed the record limit are deleted.
    Important: Records are deleted when they exceed a threshold equals to 0.1% of the limit value. For example, if Record limit is set to 10000, once 10010 records are reached, the 10 oldest records are automatically deleted.