Table¶
Properties¶
Name |
BrowseName |
DataType |
Description |
|---|---|---|---|
| Record limit | RecordLimit |
Maximum limit of records (rows) in the table. When the limit is reached, the new data replace the old data in rotation. |
|
| Columns | Columns |
Collection of StoreColumn |
Table columns. Collection of StoreColumns. For ODBC database: Microsoft SQL Server maximum columns limit = 1000, maximum limit of characters in the column = 128; MySQL Server maximum columns limit = 1024, maximum limit of characters in the column = 64. For embedded database: maximum columns limit = 2000, maximum limit of characters in the column = 1024. |
Methods¶
Add column¶
BrowseName: AddColumn
InputArguments
Name |
DataType |
Description |
|---|---|---|
Name |
String |
Column name |
DataType |
NodeId |
Column DataType |
Rename column¶
BrowseName: RenameColumn
InputArguments
Name |
DataType |
Description |
|---|---|---|
OldName |
String |
Name of column to be renamed |
NewName |
String |
The new column name |
Insert¶
BrowseName: Insert
InputArguments
Name |
DataType |
Description |
|---|---|---|
ColumnNames |
String |
Column names for insert |
Values |
BaseDataType |
List of records to be inserted |