FB_DBRecordInsert

FB_DBRecordInsert 1:

The function block FB_DBRecordInsert can be used to write individual records with any structure into a database. To use the function block it is necessary to declare the database to which the records are to be written in the XML configuration file.

VAR_INPUT

VAR_INPUT
    sNetID    : T_AmsNetId;
    hDBID     : UDINT;
    sInsertCmd: T_MaxString;
    bExecute  : BOOL;
    tTimeout  : TIME;
END_VAR

sNetID: String containing the AMS network ID of the target device, at which the ADS command is directed.

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

sInsertCmd: Indicates which INSERT command is to be executed.

bExecute: The command is executed with a rising edge.

tTimeout: Indicates 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 as long as bBusy remains TRUE.

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

nErrID: Returns the ADS error code or TcDatabaseSrv_Error_Codes if the bError output is set.

sSQLState: Returns the SQL error code of the corresponding database type

Requirements

Development environment	Target system type	PLC libraries to be linked
TwinCAT v3.0.0	PC or CX (x86)	Tc2_Database