FB_SQLDatabase

Function block for opening, closing and managing a database connection.
Syntax
Definition:
FUNCTION BLOCK FB_SQLDatabase
VAR_INPUT
sNetID: T_AmsNetID := '';
tTimeout: TIME := T#5S;
END_VAR
VAR_OUTPUT
bBusy: BOOL;
bError: BOOL;
ipTcResultEvent: Tc3_EventLogger.I_TcResultEvent;
END_VAR
Inputs
Name | Type | Description |
---|---|---|
sNetID | T_AmsNetID | AMS network ID of the target device at which the ADS command is directed. |
tTimeout | TIME | Indicates the time before the function is cancelled. |
Outputs
Name | Type | Description |
---|---|---|
bBusy | BOOL | TRUE as soon as a method of the function block is active. |
bError | BOOL | TRUE when an error occurs. |
ipTcResultEvent | Tc3_EventLogger.I_TcResultEvent | Result interface with detailed information on the return value. |
Methods
Name | Definition location | Description |
---|---|---|
Local | Opens a connection to a declared database. | |
Local | Initializes an instance of the function block FB_SQLCommand with the already open database connection of the function block FB_SQLDatabase. | |
Local | Initializes an instance of the function block FB_SQLStoredProcedure with the already open database connection of the function block FB_SQLDatabase. | |
Local | Closes the connection to the database that was opened by this function block instance. |
Requirements
Development environment |
Target platform |
PLC libraries to be linked |
---|---|---|
TwinCAT v3.1 Build 4020.10 |
PC or CX (x86) |
Tc3_Database |