FB_SQLStoredProcedure
Function block for executing stored procedures of the database. Before it can be used it has to be initialized with the function block "FB_SQLDatabase".
Syntax
Definition:
FUNCTION BLOCK FB_SQLStoredProcedure
VAR_INPUT
sNetID: T_AmsNetID := '';
tTimeout: TIME := T#5S;
END_VAR
VAR_OUTPUT
bBusy: BOOL;
bError: BOOL;
ipTcResultEvent: Tc3_EventLogger.I_TcResultEvent;
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. |
ipTcResultEvent | Tc3_EventLogger.I_TcResultEvent | Result interface with detailed information on the return value. |
Methods
Name | Definition location | Description |
|---|---|---|
Local | Sends the call of the specified stored procedure to the database via the database connection already opened by the function block FB_SQLDatabase. | |
Local | Sends the call of the specified stored procedure to the database via the database connection already opened by the function block FB_SQLDatabase. An instance of the FB_SQLResult function block can be transferred for reading the returned records. | |
Local | Releases the parameter information of the stored procedure that was transferred during initialization. |
Requirements
|
Development environment |
Target platform |
PLC libraries to be linked |
|---|---|---|
|
TwinCAT v3.1 Build 4020.10 |
PC or CX (x86) |
Tc3_Database |