FB_SQLDatabase

FB_SQLDatabase 1:

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

FB_SQLDatabase 2: 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.

FB_SQLDatabase 3: 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.

FB_SQLDatabase 4: Methods

Name

Definition location

Description

Connect

Local

Opens a connection to a declared database.

CreateCmd

Local

Initializes an instance of the function block FB_SQLCommand with the already open database connection of the function block FB_SQLDatabase.

CreateSP

Local

Initializes an instance of the function block FB_SQLStoredProcedure with the already open database connection of the function block FB_SQLDatabase.

Disconnect

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