ST_SQLSPParameter

This structure is required for the function block FB_SQLStoredProcedureEvt to describe the different parameters of the procedure to be executed.

Syntax

Definition:

TYPE ST_SQLSPParameter :
STRUCT
    eParameterType: E_SPParameterType;
    eParameterDataType: E_ColumnType;
    nParameterSize: UDINT;
    sParameterName: STRING(50);
END_STRUCT
END_TYPE

Name

Type

Description

eParameterType

E_SPParameterType

Parameter type (INPUT, OUTPUT ..)

eParameterDataType

E_ColumnType

Parameter type

nParameterSize

UDINT

Parameter length

sParameterName

STRING (50)

Parameter name

Requirements

Development environment

Target platform

PLC libraries to be linked

TwinCAT v3.1 Build 4020.10

PC or CX (x86)

Tc3_Database