Feedback
  1. Home
  2. applications
  3. grid application
  4. Creating a Grid/Report Application

Creating a Grid/Report 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.

List of applications that can be created.

Application Data

Required fields for creating applications

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.

Table

Defines the tables to be used in the application. (Form and Calendar can only use one table).

Fields

Defines the fields that will be part of the applications.

Localization

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

SQL

Displays the SELECT command generated after selecting the tables and fields. This field also allows the insertion of a previously created SQL statement, as long as it uses tables that exist in the database selected in the connection.

Create also a Form to edit the Grid

This option creates a form application linked to the grid, automatically establishing an edit link between the applications. For more details about the edit link, click here.

This option is available only when the grid is created using a table.

When this option is selected, a dialog box will appear asking the developer to define the default behavior for creating future grid applications.

Set a default pattern for automatic form creation

  • Create also a Form to edit the Grid - Defines the default behavior for creating future grid applications.
  • Always display this message - Determines whether this dialog box will always be displayed.

This configuration can be modified later by accessing the menu Options > My Scriptcase.

After confirming the default behavior, you will need to specify the name of the form to be created.

Pattern for creating a grid linked to a form

Run application after creation

This option defines whether the grid will be executed after it is created.

Option to run the grid after creating the application.

When this option is selected, a dialog box will appear where the default behavior of Scriptcase for creating other grids in the project must be defined.

Dialog box for setting the standard behavior to run the grid after creation

You can configure the grid to run by default by selecting the option Run the application after creation and clicking save.

If you deselect the option Always show this message, this dialog box will no longer appear.

This configuration can be changed later by accessing the menu Options > My Scriptcase.

Relationship

When select two or more tables, the tab “Relationship” will be displayed. In this tab we can see the relationship created between the tables, where we can edit the related fields.

Tela de relacionamento das aplicações

When we click in a link, in the screen above, it will displayed the related field’s edition form, as you can see in the image below.

Campos relacionados

Editing Fields

This screen displays the fields of the selected tables and allows adjustments to be made before creating the application, such as changing the data type, display name, and other configurations.

List of fields in the grid creation process

Fields

Names of the database fields.

Label

Names of the fields in the generated application’s interface.

Datatype

Specifies the field’s data type.

Grid

Defines the fields available in the grid.

Defines the fields available in the filter.

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