FB_SQLStoredProcedure

FB_SQLStoredProcedure 1:

Function block for executing stored procedures of the database. Before it can be used it has to be initialized with the function block "FB_SQLDatabase".

Syntax

Definition:

FUNCTION BLOCK FB_SQLStoredProcedure
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_SQLStoredProcedure 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_SQLStoredProcedure 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_SQLStoredProcedure 4: Methods

Name

Definition location

Description

Execute

Local

Sends the call of the specified stored procedure to the database via the database connection already opened by the function block FB_SQLDatabase.

ExecuteDataReturn

Local

Sends the call of the specified stored procedure to the database via the database connection already opened by the function block FB_SQLDatabase.

An instance of the FB_SQLResult function block can be transferred for reading the returned records.

Release

Local

Releases the parameter information of the stored procedure that was transferred during initialization.

Requirements

Development environment

Target platform

PLC libraries to be linked

TwinCAT v3.1 Build 4020.10

PC or CX (x86)

Tc3_Database