FB_DBRecordDelete

FB_DBRecordDelete 1:

The FB_DBRecordDelete function block allows to delete data records out of a database. The length of the SQL - command could be till 10000 symbols. For using this function block you have to declare the database, you want to delete from, in the XML - configuration file.

VAR_INPUT

VAR_INPUT
    sNetID          : T_AmsNetId;
    hDBID           : UDINT;
    cbCmdSize       : UDINT;
    pCmdAddr        : UDINT;
    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 length of the INSERT command.

pCmdAddr : Pointer to the executed INSERT command.

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

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)	TcDatabase.Lib