FB_DBStoredProceduresRecordArray
The function block FB_DBStoredProceduresRecordArray can be used to call stored procedures that return records. In contrast to the FB_DBStoredProceduresRecordReturn function block, this function block can be used to return several records with a single call. They can include parameters in the process, which are used in the stored procedures.
VAR_INPUT
VAR_INPUT
sNetID : T_AmsNetID :='';
hDBID : UDINT :=1;
sProcedureName : T_MaxString :='';
cbParameterList : UDINT;
pParameterList : POINTER TO ARRAY[0..MAX_STORED_PROCEDURES_PARAMETERS] OF ST_DBParameter;
nStartIndex : UDINT;
nRecordCount : UDINT
cbRecordArraySize: UDINT;
pDesAddr : POINTER TO BYTE;
bExecute : BOOL;
tTimeout : TIME := T#15s;
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.
sProcedureName: Indicates the name of the procedure to be executed.
cbParameterList: Indicates the length of the parameter list.
pParameterList: Contains the address of the parameter list
nStartIndex: Indicates the index of the first record to be read.
nRecordCount: Indicates the number of records to be read.
cbRecordArraySize: Indicates the size of the structure array in bytes.
pDestAddr: Indicates the address of the structure array into which the records are to be written.
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;
nRecords : UDINT;
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
nRecords: Returns the number of data records.
Requirements
|
Development environment |
Target system type |
PLC libraries to be linked |
|---|---|---|
|
TwinCAT v3.0.0 |
PC or CX (x86) |
Tc2_Database |