Stored Procedures

Executing Stored Procedures

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.

ExecuteStoredProcedure Activity

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.