Table

Database table.
BrowseName
Table
SuperType
Object(BaseObjectType)

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
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
Column name
DataType
Column DataType
Remove column
BrowseName
RemoveColumn
InputArguments
Name
DataType
Description
Name
Rename column
BrowseName
RenameColumn
InputArguments
Name
DataType
Description
OldName
Name of column to be renamed
NewName
The new column name
Insert
BrowseName
Insert
InputArguments
Name
DataType
Description
ColumnNames
Column names for insert
Values
List of records to be inserted
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.