XML database
This section contains information on the configuration and the data type mapping of XML files as databases. The database structure, tables and columns are defined in an XSD file. The XML file, the XSD file and an XSL file containing style information are created with the TwinCAT Database Server configurator (Create command). Based on the XSL file the XML file can be opened in a web browser, where a graphical enhance view of the database or the table is presented.
Further information on working with XML files as databases can be found in section "XML - information".
Declaration in the TwinCAT Database Server Configurator
XML database | |
---|---|
Database Type | Select "XML" from the drop-down menu. |
XML Database File | Enter the name and path of the XML file. |
XML Schema File | Enter the name and path of the XSD file. |
Database | Enter the name of the database. If the database does not yet exist, it can be created with the Create button. Corresponding permissions must exist. In the case of XML databases, the XML, XSD and XSL files are created automatically. |
Windows CE support This database is also supported by the Windows CE version of the TwinCAT Database Server. The connection can be established locally. |
Data type mapping between DB and PLC
E_ColumnTypes | XML | TwinCAT PLC |
---|---|---|
BigInt | bigint | T_ULARGE_INTEGER (TcUtilities.lib) |
Integer | integer | DINT |
SmallInt | smallint | INT |
TinyInt | tinyint | BYTE |
Bit_ | bit | BOOL |
Money | money | LREAL |
Float | float | LREAL |
Real_ | real | LREAL |
DateTime | datetime | DT |
NText | ntext | STRING |
NChar | nchar | STRING |
Image | image | ARRAY OF BYTE |
NVarChar | nvarchar | STRING |
Binary | binary | ARRAY OF BYTE |
VarBinary | varbinary | ARRAY OF BYTE |
Data type support WSTRING is not supported by this database. (See WString support) |
Notice | |
Data security In flash memory devices the number of write access operations is limited. The flash memory devices can fail, with a risk of data loss.
|