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 Properties | Description |
|---|---|
| SQL Server Connection String | The 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 Name | The name of the Stored Procedure which would be executed |
| Stored Procedure Parameter | The parameters which will be passed to the Stored Procedure during execution |
Updated 5 months ago