Feedback Print

Visão Geral

Scriptcase Applications

The Scriptcase offers a wide range of applications that allows the developer to create a complete system. The Scriptcase also allows the integration of the applications with external libraries, boosting its power in the systems development.

See below the available types of applications.

Grid

Application used to display data, this application serves as a report where we can do exports to PDF, XLS, XML, and other formats.

Procedure

Similar to the grid application, this application is available for few databases (MSSQL Server, Oracle and Db2) when selecting the connection, in case the user have a procedure that returns information it will be displayed in this special application.

Form

Application used to insert and update data, there are four different types of orientations.

Tabs

This application allows the creation of tabs where we can put up other applications like grids and forms.

Control

This application is used to create controls in a system, it is not linked to a table, and it needs the creation of one or more fields to its operation. A example of using is in the creation of a login screen.

It is used to create a hierarchical structure to navigate through the system’s applications. There are two types of menu available in Scriptcase, Horizontal Menu and Tree Menu, that differs only in the preview of its items.

Application used to create searchs exclusively to forms.

Report PDF

Application used to generate reports using pre set formats, where we can position the data in the report.

Dashboard

Allows the developer to display applications inserted in widgets.

Blank

This application allows the insert of PHP code / HTML and displays the result of its processing. The advantage of using this application is the possibility of using macros and the native integrations with the other applications.

Calendar

Application where we can maintain an event schedule that can be synchronized to the google calendar.

Batch Applications Creation

With this tool, it is possible to create multiple applications (Form and Grid).

When creating grids and forms using the same table, the applications are created with an application link between them, allowing to edit the record from the Grid application.

To start the process of creating the application, you need to select a connection so that the tables can be listed.

Select the connection that you want to use

Next, you need to select the tables that are going to be used to create the applications. When selecting the tables, you can define which applications (Forms and Grids) are going to be created.

Selecting the tables and applications for the creation

For last, you need to define the name, description and type, in case for the Forms.

Adjusting the applications that are going to be created

  • Name - Name of the application that is going to be created.
  • Description - Application Description.
  • Type - This option is only available for Forms, defines the type of form that is going to be created (Single Record, Multiple Rows, Editable Grid and Editable Grid “View”).
  • Generate Source - Selecting this option all the applications to be created will have their source code generated.
  • To edit - Selecting this option all the applications created will be open for modifications right after creation.

Restore Applications

This feature allows to restore the project’s applications that has been modified recently. When saving the application, ScriptCase stores automatically a limited number (defined in Settings > System Settings on the option Number of automatic application copies) of copies of the application, so that they can be restored. First, we need to select the application that you want to restore.

Select the desired application

Previously, you need to select the restore point that you desire and also define a name for the restored application.

Selecting the restore point and defining the app name

Save Applications

This option saves the application opened in the edition mode. This option can be found inside the applications menu or in the default toolbar, also being possible to use the shortcut CTRL+S.

Importar aplicação

Generate Source

Different from the generate source code found in Project, this option saves and only generate the source code of the opened application in edition mode. This option can be found inside the menu Applications or in the default toolbar, and it is also possible to use the shortcut F8.

Gerar fonte

Execute Application

Saves and execute the application that is opened in the edition mode. This option can be found inside the Application menu of in the default toolbar, and it is also possible use the shortcut F9.

Executar aplicação

Export Applications

Every application of a project or some applications can be exported. In this export, not only the application but also the needed archives to its operation of the selected applications are exported.

This option can be found inside the menu Application.

Firstly you need to select if you want to export all applications or if you want to select some applications.

Exportar aplicações

When select all applications, it will be displayed with the export log and the link to donwload the generated file.

In this example, we choose to “Select Applications”, in this case the applications are listed according to the type or folder.

Lista de aplicações

To proceed, select the desired applications and clieck in export. After this it will be displayed a log of the exported files and a link to download the generated file.

Log da exportação

Import Applications

Allows the developer to import applications created in the same version of Scriptcase. This option can be found inside the menu Application.

After the import application screen is displayed, select the file you want to import.

Importar aplicacao

The options are:

Opcoes Importacao

Overwrite - Overwrites the project’s files by the files that are being imported. Don’t overwrite – Keeps the project’s files, ignoring the files that are being imported. Rename – Keep the project’s and import the files selected with the defined names.

In the next step, show a summary that will be restored.

Resumo dos arquivos restaurados

Source code

In this option is possible to see the application’s source code after it generates.

Código fonte

Session data

In this option, it is possible to see every session variable available in the development environment, it is the session tree that Scriptcase stores.

Dados de sessão