Configures a form application to use Stored Procedure (defined by the database) for adding, updating, and excluding information. When not configured to use procedures the default is to use Scriptcase standards for the commands INSERT, UPDATE and DELETE.
See below step-by-step implementation for Stored Procedure Database Insertion.
Image1: Stored Procedures Interface
1 - Mark the option: “I want to use Procedure to do INSERT”. Enter the procedure name and the amount of parameters.
Image2: Defining procedure parameters.
2- Define the fields that reference to the Stored Procedure parameters and each parameter type (input or output). Click on the button save to complete this process.
Image3: Passing values to the Stored Procedure.