FB_SQLCommandEvt

FB_SQLCommandEvt 1:

Function block for executing SQL commands. Before it can be used it has to be initialized with the function block FB_SQLDatabaseEvt.

Syntax

Definition:

FUNCTION BLOCK FB_SQLCommandEvt
VAR_INPUT
    sNetID: T_AmsNetID := '';
    tTimeout: TIME := T#5S;
END_VAR
VAR_OUTPUT
    bBusy: BOOL;
    bError: BOOL;
    ipTcResult: Tc3_EventLogger.I_TcMessage
END_VAR

FB_SQLCommandEvt 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_SQLCommandEvt 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.

ipTcResult

Tc3_EventLogger.I_TcMessage

Message interface from the TwinCAT 3 EventLogger, which provides details on the return value.

FB_SQLCommandEvt 4: Properties

Name

Type

Access

Description

eTraceLevel

TcEventSeverity

Get, Set

Specifies the weighting of the events. Only events with a weighting higher than this value are sent to the TwinCAT system.

FB_SQLCommandEvt 5: Methods

Name

Definition location

Description

Execute

Local

Sends the specified SQL command to the database via the database connection already opened by the function block FB_SQLDatabaseEvt.

ExecuteDataReturn

Local

Sends the specified SQL command to the database via the database connection already opened by the function block FB_SQLDatabaseEvt.

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

Requirements

Development environment

Target platform

PLC libraries to include

TwinCAT v3.1 Build 4022.20

PC or CX (x86)

Tc3_Database