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.
Click to property button to configure or select the data source
Select the type of stored procedure indicating the type of result returned.
The name of the stored procedure
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.
If the stored procedure uses parameters, specify them with this collection property.
Use FirstRecord to read the first record from the stored procedure or AllRecords to read all records.
Design time property to get the record count if the stored procedure returns records.