FB_DBRecordSelect_EX

FB_DBRecordSelect_EX 1:

The FB_DBRecordSelect_EX allows individual data records to be read from a database. The length of the SQL-command could be till 10000 Symbols.
 

This function block is not compatible with ASCII files.

 

VAR_INPUT

VAR_INPUT
    sNetID          : T_AmsNetID;
    hDBID           : UDINT;
    cbCmdSize       : UDINT;
    pCmdAddr        : UDINT;
    nRecordIndex    : UDINT;
    cbRecordSize    : UDINT;
    pDestAddr       : DWORD;
    bExecute        : BOOL;
    tTimeout        : TIME;
END_VAR

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

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

cbCmdSize          : Indicates the size of the SELECT command.

pCmdAddr           : Pointer to the executed SELECT command.

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 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

TwinCAT v2.10.0

CX (ARM)