FB_PLCDBCmdEvt

FB_PLCDBCmdEvt 1:

Function block with two methods. Users can define and transfer their own SQL commands. Placeholders in the SQL command can correlate with structures in the PLC, which reflect the table structure. The database server enters the current data of the structure into the SQL command.

Syntax

Definition:

FUNCTION_BLOCK FB_PLCDBCmdEvt
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_PLCDBCmdEvt 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_PLCDBCmdEvt 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_PLCDBCmdEvt 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.

Methods

Name

Definition location

Description

Execute

Local

Sends any SQL commands to the database.

Returned records cannot be read.

ExecuteDataReturn

Local

Sends any SQL commands to the database.

A specified number of records can be read.

Requirements

Development environment

Target platform

PLC libraries to include

TwinCAT v3.1 Build 4022.20

PC or CX (x86)

Tc3_Database