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
      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.
      TIP: The
      Timestamp
       or
      Time
       columns are automatically added to the table if you use a database to store data from a logger.
    • The minimum
      Record limit
       value is
      1000
      .
    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.
Normal