FB_DBStoredProceduresRecordReturn

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;
    nRecordIndex    : UDINT;
    cbRecordSize    : UDINT;
    pRecordAddr     : 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.

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

cbRecordSize             : Provides the size of a data record in bytes.

pDestAddr                   : Provides the address of the structure into which the data record is 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 as long as "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