FB_SQLResult

FB_SQLResult 1:

The function block is used for reading the cached records.

Syntax

Definition:

FUNCTION BLOCK FB_SQLResult
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_SQLResult 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_SQLResult 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_SQLResult 4: Methods

Name

Definition location

Description

Read

Local

Reads a specified number of records from the result data cached in the TwinCAT Database Server.

Release

Local

Releases data buffered by the TwinCAT Database Server.

Requirements

Development environment

Target platform

PLC libraries to be linked

TwinCAT v3.1 Build 4020.10

PC or CX (x86)

Tc3_Database