Feedback

Procedures

This interface allows configuring a Form application to execute the Stored Procedures from your database for Insert, Update and Delete records in the form. You don’t need to use the three options simultaneously. If a Procedure option is not enabled, it continues to work as default by using the INSERT, UPDATE and DELETE commands.

See below, the step-by-step to enable a Stored Procedure for inserting records into the database.

Form Stored Procedures Interface. Form Stored Procedures Interface.

  • Let’s check the first option: “Enable INSERT Procedure”. Then, inform the Name of the Procedure and the number of parameters.

Defining parameters for the Procedure. Defining parameters for the Procedure.

  • Now associate the fields for each parameter of the Stored Procedure and the type of parameter (Input or Output). Click on the “Save” button to finish.

Passing value to the Stored Procedure Parameters. Passing the values to the Stored Procedure Parameters.