ODBC - Firebird Database
The values of the variables are saved in an Firebird Database.
The variable values are saved in the following table structure.
Column name | Data type | Null permitted | Characteristic |
|---|---|---|---|
ID | BIGINT | no | IDENTITY(1,1) |
Timestamp | TIMESTAMP | no |
|
Name | TEXT | no |
|
ValueType="Double" | |||
Value | FLOAT | no |
|
ValueType="Bytes" | |||
Value | BLOB | no |
|
An AutoID is generated in the "ID" column. The value in this column is, in other words, always increased by 1.
The "Timestamp" column stores the time at which the data record was saved.
The name of the variable is stored in the "Name" column.
The "Value" column stores the value of the variable.
E_DBColumnTypes | FireBird | PLC Control |
|---|---|---|
eDBColumn_BigInt | BIGINT | T_ULARGE_INTEGER (TcUtilities.lib) |
eDBColumn_Integer | INTEGER | DINT |
eDBColumn_SmallInt | SMALLINT | INT |
eDBColumn_TinyInt | SMALLINT | INT |
eDBColumn_Bit | CHAR(1) | BYTE |
eDBColumn_Money | DEZIMAL(18,4) | LREAL |
eDBColumn_Float | FLOAT | REAL |
eDBColumn_Real | DOUBLE PRECISION | LREAL |
eDBColumn_DateTime | Timestamp | DT |
eDBColumn_NText | VARCHAR(254) | STRING |
eDBColumn_NChar | CHAR(254) | STRING |
eDBColumn_Image | BLOB | ARRAY OF BYTE |
eDBColumn_NVarChar | VARCHAR(254) | STRING |
eDBColumn_Binary | BLOB | ARRAY OF BYTE |
eDBColumn_VarBinary | BLOB | ARRAY OF BYTE |