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.
Application used to display data, this application serves as a report where we can do exports to PDF, XLS, XML, and other formats.
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.
Application used to insert and update data, there are four different types of orientations.
This application allows the creation of tabs where we can put up other applications like grids and forms.
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.
Application used to generate reports using pre set formats, where we can position the data in the report.
Allows the developer to display applications inserted in widgets.
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.
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.
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.
In this article, you learn how to edit various application at the same time. Using the Express Edit tool, you can define values for various common attributes for these applications. It is useful specially to add updates to your applications.
Only some settings are available within the Express Edit tool.
This tool can be accessed from the menu Tools > Express Edit.
Firstly, You need to inform which applications You want to edit.
You edit all the applications in the project, with no exceptions.
All the applications existing in the project are listed so that you can select the applications that you want to edit.
After selecting the applications, you define the modifications that you want for those applications. On this page, You can define how the modifications are applied.
Appling to all the applications
This option allows applying the same configurations, to all the selected applications, automatically.
Define the image for the header of the applications.
Define the use of security on the applications of the project.
Enable direct call by URL
Allow the applications to be called directly by the URL.
It enables “Cross-Site Request Forgery” protection. (This option only applies for the Control and Form applications)
Show HTML content
Defines if the HTML code stored in the database is interpreted or not by the browser. (This option only applies for the Grid application)
Remove the HTML tags
Defines if the HTML code stored in the database will have the HTML tags removed for display.
Save HTML tags
Stores the HTML tags informed within the Application field to the database. (This option only applies for the Form application)
It allows you to transform the Fields labels in static labels when you scroll down the page.
It allows you to apply the Select2 as default in the applications.
Grid export modules
It allows you to select the Grid Modules in the exportation.
Export with Password
It allows defining a password in the Applications exportation.
Select columns of Export
It allows selecting the desired application columns in the exportation.
It allows the Scriptcase to distinguish the letters uppercase and loYourcase.
It allows using the alerts messages with SYouetAlert components.
It allows that all Scriptcase error messages use Toast error messages.
It applies the selected language for all the selected applications in the project.
It applies the desired connection (Connections created in the “New Connection” module) for the applications.
Connection for fields
It applies the desired connection (Connections created in the “New Connection” module) for the fields in the applications.
It applies the desired Theme (Only the ones included in the Project properties) to all the applications.
it allows configuring the hotkey template for all applications.
It allows resetting the application toolbar settings.
Change the Header and Footer template of the applications.
After selecting the modifications that you want to do for all the applications, you see a list with all the selected attributes.
This option allows you to apply the modifications individually for each application selected. This option contains not only the previous attributes, but also three exclusive attributes.
It applies a description individually for the selected applications.
It applies a friendly URL individually for each selected application.
It applies the title individually for each application.
After selecting the modifications individually for all the select applications, It displays a list with all the selected attributes listed for modification.
When you apply the modifications, It displays a list of the applications that Youre modified.
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.
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.
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.
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.
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.
To proceed, select the desired applications and click in export. After this it will be displayed a log of the exported files and a link to download the generated file.
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.
The options are:
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.
In this option is possible to see the application’s source code after it generates.
In this option, it is possible to see every session variable available in the development environment, it is the session tree that Scriptcase stores.