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