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
- InProject view, select aDatabaseobject.
- InProperties, next toTables, select to add a database table.
- Next toColumns, select to create a table column.
- (optional) To change the data type of the column value, next toColumn, select#BaseDataTypeand select a different data type.
- Enter aColumnvalue or create a dynamic link.#
- (optional) To change the column name. hover overColumn, select , and enter a custom name.#
- If you use an embedded database, setRecord limit.
- The minimumRecord limitvalue is1000.
- TheRecord limitproperty only takes effect if there is at least one column in the table namedTimestamporTimeand has theDateTimedata type. TheTimestamporTimecolumns 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 to0.1%of the limit value. For example, ifRecord limitis set to10000, once10010records are reached, the10oldest records are automatically deleted.
Provide Feedback