Stored Procedures
Last updated
Last updated
appRules supports the execution of stored procedures. For database engines that support stored procedures, appRules includes the ExecuteStoredProcedure activity for executing stored procedures. If the stored procedure returns records, the records and the fields they contain can be read from the database and utilized in appRules just like any other records and fields.
For example, to execute a stored procedure in SQL Server, drag and drop the ExecuteStoredProcedure activity from the SQL Server Toolbox on to the designer and configure the properties.
Property
Description
Datasource
Click to property button to configure or select the data source
StoredProcedureType
Select the type of stored procedure indicating the type of result returned.
StoredProcedure
The name of the stored procedure
StoredProcedureFields
This collection property specifies the data fields in the stored procedure. Only the field name and field type is required when defining the field. The field name must match the column name used in the stored procedure.
StoredProcedureParams
If the stored procedure uses parameters, specify them with this collection property.
AutoLoad
Use FirstRecord to read the first record from the stored procedure or AllRecords to read all records.
RecordCount
Design time property to get the record count if the stored procedure returns records.
