FB_DBStoredProceduresRecordArray

FB_DBStoredProceduresRecordArray 1:

With this function block FB_DBStoredProceduresRecordArray you can start stored procedures which return data records. The difference between the FB_DBStoredProcedureRecordReturn and this function block is, the FB_DBStoredProcedureRecordArray can return more than one record with one execution. It is possible to declare parameters which will be used in the stored procedures.

VAR_INPUT

VAR_INPUT
    sNetID      : T_AmsNetID        :='';
    hDBID       : UDINT             :=1;
    sProcedureName  : T_MaxString   :='';
    cbParameterList : UDINT;
    pParameterList  : POINTER TO ARRAY[0..MAX_STORED_PROCEDURES_PARAMETERS] OF ST_DBParameter;
    nStartIndex     : UDINT;
    nRecordCount    : UDINT
    cbRecordArraySize       : UDINT;
    pDesAddr        : DWORD;
    bExecute        : BOOL;
    tTimeout        : TIME         := T#15s;
END_VAR

sNetID : Is a string containing the AMS network identifier of the target device to which the ADS command is directed.

hDBID : Is the ID of the database to be used.

sProcedureName : Provides the name of the stored procedure.

cbParameterList : Provides the size of a parameter list in bytes.

pParameterList : Provides the address of a parameter list.

nStartIndex : Gives the index of the first data record that is to be read.

nRecordCount : Gives the count of data records that are to be read.

cbRecordArraySize : Provides the size of an array structure in bytes.

pDestAddr : Provides the address of the array structure into which the data records are to be written.

bExecute : The command is executed with the rising edge.

tTimeout : States the time before the function is cancelled.

VAR_OUTPUT

VAR_OUTPUT
    bBusy       : BOOL;
    bError      : BOOL;
    nErrID      : UDINT;
    sSQLState   : ST_DBSQLError;
    nRecords    : UDINT;
END_VAR

bBusy : The command is in the process of being transmitted by ADS. No new command will be accepted if "bBusy" remains TRUE.

bError : Becomes TRUE, as soon as an error occurs.

nErrID : Supplies the ADS Error Code or the TcDatabaseSrv_Error_Codes when the bError output is set.

sSQLState : Supplies the SQL error code of the specified database type.

nRecords : Returns the number of data records.

Requirements

Development environment	Target system type	PLC libraries to be linked
TwinCAT v2.10.0	PC or CX (x86)	TcDatabase.Lib (from Version 1.0.17)
TwinCAT v2.10.0	CX (ARM)	TcDatabase.Lib (from Version 1.0.17)