ScriptCase offers various applications that allows the developer to create a complete system, also offers the integration of the applications with the external libraries giving more potential for the tool on developing the systems.
See the types of applications available below.
- Grid – An application that displays data, this application has the behavior of a report, where you can export to PDF, XLS, XML and other formats.
- Procedure – Similar to the Grid, this application is only available for a few databases (MSSQL Server, Oracle and Db2) when selecting a connection, in case there’s a procedure that returns information, this application will be displayed.
- Form - An application that allows to insert and update data, there are 4 types of orientations.
- Single Record – Manipulate only 1 record per page.
- Multiple Records – Manipulate various records per page where the interaction can be done on various lines at the same time.
- Editable Grid – Various records per page, where each interaction with the records needs to be done individually and all the lines are enabled for modifications.
- Editable Grid View - Various records per page, where each interaction with the records needs to be done individually and the lines are disabled for modifications, to edit the records you need to click on the edit icon next to the record line you want to edit.
- Tabs – This application allows you to create tabs where you can place other applications in, like the Grid and Form applications.
- Control – This application is used to make custom controls in a system, it’s not tied to a table, and requires the creation of at least one field for it to work. An example for that is the creation of a login screen.
- Menu - Allows to create a hierarchical navigation structure of the system applications. There are two types of menus available, Horizontal Menu and Tree Menu, that the difference is only the display.
- Search - This application is used exclusively with the Form application.
- PDF Report – This application is responsible for generating the reports using some predefined formats, where you can position the data in the report.
- Dashboard – Allows you to display various applications placed in widgets.
- Blank – This application allows you to insert PHP / HTML code to display some processing results. The advantage of using this application is the possibility of using the macro and native integration with the other applications.
- Calendar – An application where you can maintain an agenda of events, it can also be linked to the google calendar.
The process of creating an application is simple and intuitive. First select the application desired.
On this tab you need to select a connection (only in the case it needs it) that will be used by the application. Selecting the connection, the tables will be loaded and listed in the Tables Field.
It is possible to select more tables when creating the applications, with the exceptions the Form and Calendar.
After selecting the tables and the fields that is going to be part of the application, you need to inform the name and language.
- Connection - Define a connection that is going to be used while creating the application. It will list the existing project’s connections.
- Table - Defines the tables that will be used in the application. (Forms and Calendars only use one table).
- Fields - Defines the fields that are part of the applications.
- SQL Select Statement - Displays the the Select statement created after selecting the tables and the field. This field allows to insert a SQL previously created, although it needs to contain the tables that exist in the selected database connection.
- Name - Name of the applications that is being created, it can not contain special characters.
- Localization - Language of the application created. The default project language is selected automatically.
When selecting two or more tables, the Relationship tab will be displayed. On this tab, you will view the relationship created between the tables, where you can edit the field relationship.
Below is the form to edit the field relationship.
List of fields that will be created in the application, like their names and display types. Here you can do some configurations on the fields, like the modifications for the label or it is data type.
In case of a SQL error when creating an application, this screen will display blank.
- Fields - Fields’ name in the database.
- Label - Fields’ name that will be displayed in the generated application.
- Datatype - Data Type of Field.
- Grid - Defines the fields available in the Grid.
- Search - Defines the fields available in the Search.
Application’s schema definition, the default project’s theme (that can be viewed in Project > Properties) will be selected automatically.
- Schemas - List of schemas available in the project.
After creating the application, you will be redirected to the configuration of the application created.
Batch Application 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.
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.
For last, you need to define the name, description and type, in case for the Forms.
- 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.
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.
Previously, you need to select the restore point that you desire and also define a name for the restored application.
This option saves the application that’s open in edit mode. This option can be found in the Application’s menu or on the toolbar.
Generate Source Code
Different from generating the source code found in the project menu, this option saves and generates the source code only for the application that’s open in edit mode. This option can be found in the Applications menu or in the standard toolbar.
Saves and runs the application that is open at the moment in edit mode. This option can be found in the Applications Menu or on the default toolbar.
This option works the same way as any deployment, the only difference is that this option is only available for the application open at the moment to edit.
For more information about deployment, access Deployment.
Allows to export all the applications of a project or you can select the desired applications. In this export, the necessary files that are used in the applications are also added to the export.
This option can be found in the Application Menu.
First, you need to select if you want to export all the applications from the project or just some applications from the project.
Selecting all the applications, the export log screen with the download link for the generated file will be displayed.
In this example, the option Select Applications was used, in this case the applications were list according to the type or folder.
To continue, select the desired applications and click on export. After that you’ll view a log of the exported files with a link to download the generated export file.
Allows you to import the applications exported by ScriptCase, although the exported applications need to be exported in the same version of ScriptCase that they are being imported to.
This option can be found in the Application Menu.
First, you need to select the file that you want to import.
Next, in case of conflict with the selected file and the existing projects, you’ll have a couple of options for you to decide.
The options are:
- Overwrite - Overwrites the files of the project with the ones being imported.
- Don’t Overwrite – Maintain the local project files and ignore the files being imported.
- Rename – Maintain the local project files and import the selected files with different names.
On the next step, a summary of the import will be displayed.