FB_PLCDBCmdEvt
Function block with two methods. Users can define and transfer their own SQL commands. Placeholders in the SQL command can correlate with structures in the PLC, which reflect the table structure. The database server enters the current data of the structure into the SQL command.
Syntax
Definition:
FUNCTION_BLOCK FB_PLCDBCmdEvt
VAR_INPUT
sNetID: T_AmsNetID := '';
tTimeout: TIME := T#5S;
END_VAR
VAR_OUTPUT
bBusy: BOOL;
bError: BOOL;
ipTcResult: Tc3_EventLogger.I_TcMessage
END_VAR
Inputs
Name | Type | Description |
---|---|---|
sNetID | T_AmsNetID | AMS network ID of the target device at which the ADS command is directed. |
tTimeout | TIME | Indicates the time before the function is cancelled. |
Outputs
Name | Type | Description |
---|---|---|
bBusy | BOOL | TRUE as soon as a method of the function block is active. |
bError | BOOL | TRUE when an error occurs. |
ipTcResult | Message interface from the TwinCAT 3 EventLogger, which provides details on the return value. |
Properties
Name | Type | Access | Description |
---|---|---|---|
eTraceLevel | Get, Set | Specifies the weighting of the events. Only events with a weighting higher than this value are sent to the TwinCAT system. |
Methods
Name | Definition location | Description |
---|---|---|
Local | Sends any SQL commands to the database. Returned records cannot be read. | |
Local | Sends any SQL commands to the database. A specified number of records can be read. |
Requirements
Development environment | Target platform | PLC libraries to include |
---|---|---|
TwinCAT v3.1 Build 4022.20 | PC or CX (x86) | Tc3_Database |