HomeGuidesRecipesAPI
HomeGuidesAPILog In

Call SQL Stored Procedure

The Call SQL Stored Procedure Action allows the designer to call a SQL Server Stored Procedure upon form Submission. The input parameters can be calculated, hardwired or mapped to responses to the form.

πŸ“˜

SQL Server connections are secure by default, encryption is expected to be enabled for these connections.

Usage

🚧

Before using the Action you must first configure the settings in Manage

Only configure this action within properties in design if you are overriding the default for a specific case

This action can be used to add, delete, update and retrieve SQL records, file binaries, and even SQL data base schema information. The action output is the server response and can be a number of things depending on the procedure sent to the server.

The response can be reference within the form or by following actions using the ['ActionName'.Response] response reference tag.

After the procedure is performed the server will return an executeScalar response with success or failure details.

Input PropertiesDescription
SQL Server Connection StringThe connection string for the SQL Server. Connection String could look like Server=myserverlocation;Initial Catalog=MyCatalog;Persist Security Info=False;MultipleActiveResultSets=True; Encrypt=True;TrustServerCertificate=True;Connection Timeout=30; or if its a data connection Data Source=IX10-VIPIN\SQLEXPRESS;Initial Catalog=SMartIQ;User ID=sa;Password=
Stored Procedure NameThe name of the Stored Procedure which would be executed
Stored Procedure ParameterThe parameters which will be passed to the Stored Procedure during execution