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