Feedback
  1. Home
  2. applications
  3. stored procedure application
  4. Creating a Procedure Application

Creating a Procedure Application

New Application

The process of creating an application is quite simple and intuitive.

You only need to select the type of application you want to generate from the list of applications available in Scriptcase, and it will be generated automatically.

This application is available only for MSSQL Server, Oracle, and Db2 databases. It is compatible only when a connection to these types of databases is selected.

List of applications that can be created.

Application Data

Required fields for creating applications

Procedure Name

In this attribute, the developer must specify the name of the stored procedure created in the database.

Connection

Defines the connection used for the creation of the application. The existing connections in the project will be listed.

Name

The name of the application being created. It cannot contain special characters.

Localization

The language of the application to be created. The project’s default language is automatically selected.

Number of Parameters

In this attribute, the developer must indicate the number of input parameters to be used. It is important to note that all parameters specified at this stage become mandatory for the application’s functionality.

After creation, it is possible to modify the parameters (add or remove) by accessing the SQL menu.

If the stored procedure has no input parameters, the developer must enter 0 in the Number of Parameters field.

Edit Fields

In this tab, we will configure the parameters specified during the application’s creation so they can be correctly defined.

List of fields in the grid creation process

Parameter

Displays the number of parameters specified in the Application Data section, under the Number of Parameters attribute.

Var Name

In this attribute, the developer must provide the name of the variables to be used in the application. These names should correspond to the parameter names defined in the database’s stored procedure.

Type

Select the data type corresponding to the stored procedure’s parameter: INT or VARCHAR.

Value

Specify a value to validate the stored procedure provided.

Theme

On this screen, you can select the theme that the application will use. The default project theme, which can be checked and modified in Project > Properties, is automatically selected.

Definição do esquema das aplicações