PLC API

Overview

The TcDatabase.lib library contains function blocks for controlling and configuring the TwinCAT database server.

Funktionsblöcke

Name	Description
FB_GetStateTcDatabase	Call state information

FB_DBConnectionAdd	Adds database connections to the XML configuration file
FB_DBAuthentificationAdd	Adds authentication information for database connections to the XML configuration file
FB_DBOdbcConnectionAdd	Adds ODBC database connections to the XML configuration file
FB_AdsDeviceConnectionAdd	Adds Ads-device connections to the XML configuration file

FB_DBReloadConfig	Reloads the XML configuration file
FB_GetDBXMLConfig	Read all databaseconfiguration out of the XML-configuration file.
FB_GetAdsDevXMLConfig	Read all Ads-deviceconfiguration out of the XML-configuration file.

FB_DBConnectionOpen	Open a connection to a database
FB_DBConnectionClose	Close a connection to a database

FB_DBCreate	Creates a new database
FB_DBTableCreate	Creates a table with any desired table structure

FB_DBRead	Reads one value out of the database
FB_DBWrite	Writes one variable value, with timestamp, into a database
FB_DBCyclicRdWrt	Starts or stops the logging/writing of variables

FB_DBRecordSelect	Reads a data record out of a table
FB_DBRecordSelect_EX	Reads a data record out of a table (commandlength <= 10000 symbols)
FB_DBRecordArraySelect	Reads some data records out of a table
FB_DBRecordInsert	Creates a new data record
FB_DBRecordInsert_EX	Creates a new data record (commandlength <= 10000 symbols)
FB_DBRecordDelete	Deletes a data record from a table

FB_DBStoredProcedure	Execute Stored Procedures.
FB_DBStoredProcedureRecordReturn	Execute Stored Procedures and return a data record.
FB_DBStoredProcedureRecordArray	Execute Stored Procedures and return a count of data records.

Funktionen

Name	Description
F_GetVersionTcDatabase	Call version information.

Datentypen

Name
ST_DBColumnCfg
ST_DBXMLCfg
ST_ADSDevXMLCfg
ST_DBSQLError
ST_DBParameter
E_DbColumnTypes
E_DBTypes
E_DBValueType
E_DBWriteModes
E_DBParameterTypes