Creating a Procedure Application

View video

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.

Application Data

Procedure Name

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

Connection

This field lists all connections in the project and defines the connection that will be used by the application.

Select the connection to list the database tables.

Connection with Data Dictionary

When the selected connection has a Data Dictionary linked to it, the dictionary name will be displayed below the Connection field.

This information indicates that the connection has a configured dictionary, which can be used to fill in the field labels with lang in the generated applications.

By clicking the dictionary name, a screen will be displayed where you can link new tables to the Data Dictionary. Use this option if the table selected to create the application has not yet been configured in the dictionary.

For more details, access the Data Dictionary documentation.

Name

Defines the name of the application that will be created. This field is required and must contain between 1 and 64 characters.

Alphanumeric characters, period (.), hyphen (-), and underscore (_) are allowed. Spaces and other special characters are not allowed.

Localization

Defines the default language of the application that will be created. By default, Scriptcase selects the Inherit project default language option, making the application automatically use the language defined as default in the project properties.

If necessary, you can select a specific language for the application. In this case, the application will use the selected language, regardless of the default language defined in the project.

After creating the application, the application language can be changed in Application > Settings. If the Inherit project default language option is selected, the language used will be defined by the project’s default language, which can be changed in Project > Properties.

Edit language charset

You can also change the charset used by the language in the application being created. To change the charset, click the edit button displayed next to the language selection field.

When clicking the button, the option to change the charset of the selected language will be displayed.

Note: This change will be applied only to the application being created. The charset defined for the languages in the project settings will not be changed.

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.

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.