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.