Configure a database table

You can manually configure a database structure and populate it with NetLogic methods or using an OPC UA client.
  1. To configure a database table
  2. In
    Project view
    , select a
    Database
    object.
  3. In
    Properties
    , next to
    Tables
    , select
    Add
    to add a database table.
  4. Next to
    Columns
    , select
    Add
    to create a table column.
  5. (optional) To change the data type of the column value, next to
    Column
    #
    , select
    BaseDataType
    and select a different data type.
  6. Enter a
    Column
    #
    value or create a dynamic link.
  7. (optional) To change the column name. hover over
    Column
    #
    , select
    Edit
    , and enter a custom name.
  8. 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.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.