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.