www.scriptcase.net

Cost ReductionUsing Scriptcase can reduce programming time signi�cantly compared to conventional development.

MultiplatformScriptcase can be used in di�erent operating systems like Linux, Windows, MAC and others.

Development Patterning All development is done using patterns throughout the team, making so much faster and easier for both corrective and evolutionary maintenance of systems developed.

Decentralized DevelopmentAll development is done through the browser, allowing access to the development team from any location via the Internet / Intranet.

InteroperabilityAllows access to di�erent databases in a single system, thus bringing greater ease and �exibility of the systems generated.

DB2®Scriptcase is a complete environment for rapid web application development based in a database.Supports relational database widely used in the market such as Oracle, DB2, SQL Server, MySQL, PostgreSQL, Sybase, MS Access, among others.Developers have used the Scriptcase for creating various types of systems such as ERPs, among others.The development environment and the systems generated can be used with all major operating systems market such as: Windows, Linux, FreeBSD, Unix, Iseries, MAC.The development environment and the systems generated can be used with the main Browsers Market such as Firefox, Chrome, Internet Explorer, Opera.

NetMake is a Brazilian company, founded over 10 years ago, having its headquarters located in Olinda - Pernambuco, one of the leading technology centers in Brazil. NetMake main focus is on creating tools for the web development environment.With a vision of the future launched in 2001, the development tool Scriptcase.Thereafter, many companies have adopted the Scriptcase as a solution for creating systems for web, due to high productivity and ease of resources.Acting strongly in Sectors Public and Private Sectors, today Netmake has a solid customer base, tact in Brazil and abroad.In order to meet the demands of the development market Netmake comes, yearly, releasing new versions of Scriptcase.

KEY BENEFITS OF USING SCRIPTCASE

DATABASE APPLICATIONS

PHP

AJAX

SCRIPTCASE

THE COMPANY

Control Application

WHAT CAN BE DEVELOPED?

Grids and Reports Applications

Form Application

Flexibility de�ning the layout (fonts, colors, images, buttons) allowing simulations and templates usage;Navigation option: forward, back, start and end;Construction of �lters with various options for the �eld, and the ability to save �lters for future use;Group by option with any number of �elds, and treeview feature;De�nition of sum/average/maximum/minimum and summary;Rapid creation of Flash charts (Bar, Pizza, Line and others)Fields selection into the Grid de�ned by the end user dinamically with the option of "one click" order.

Several types of forms such as: Simple, editable Grid, Multiple records, editable Grid ViewFlexibility to insert and update the databaseAutomatic generation �elds validation, with a simple mouse click, such as email, credit cards, date values ;Automatic formatting of dates, values and texts, open to support objects like HTML Text, Textarea, Select, Radio, Checkbox and Passoword, drop down list;Criticizes, consultation and autocomplete �elds through one �eld information;Support auto-complete �elds using AJAX;Navigation between objects without page refresh;Option to use "Stored Procedure" to perform "Inserts, Updates and Deletes"Control referential integrity across applications.

Generally used for applications that require speci�c validation form as logins among others.Application that does not need to be based on a database.Allows the addition of �elds and data validation.

Allows the triggering of batch processing.Hiden �elds allowing to hide the �eld display and keeping it value in the processing.Label �eld feature that prevents editing of the �eld value.Several options are available for formatting the control �eld and generating, according to the type �eld, a required validation.Chance of programming in the events allowing the insertion business rules.Creation of links, allowing the connection of control to other applications of the same project.

Allows you to �lter data directly from a formSetting Sql Clauses speci�c to the �lterSeveral options are available for formatting the �lter �elds and they are generated, according to the �eld type, the required validation.Allows di�erent criterias for each �lter �eld.Validation of required �elds to search.Feature that allows to save, and make it available for reuse, the values reported in the �lter by the end user.

Group up applications (forms, grid, controls, on a single screen)Incorporating applications that have data in common.

Used to generate PDF reports, thereby allowing greater customization of the generated PDF'sIt is possible to create PDF �les individually setting the position of the data in the report.Generally used for printing pre printed invoices, degrees, Comercial Invoices, and so on.

Filter and Search Application

Tab Application

Report PDF Application

Menus can be displayed in di�erent formats: Hori-zontal, Vertical, or even shaped Folders.Allows o�er to the end user a friendly interface for accessing the project applications.Allows the creation of external links to already developed systems.The Menu structure can be changed dynamically at runtime via macros programming.Access control to the menu showing only the menu items that the user has access to.Allows the creation of business rules in their events.

Allows greater harmonization in the management information displayed on the same screen for the end user.Allows you to display various types of applications in Animated Widgets like those used by iGoogle.Generally reports and / or charts are incorporated to this application to display information extracted from the database.Information can be displayed external URL's.

This type of application allows the developer to write PHP/HTML code and display the result of a process.A good example of its use is the calling of batch processes, the advantage of using this application instead of creating a PHP program manually, outside Scriptcase, is the possibility of using Script-case macros as well as a native integration with access control to their applications.

A calendar applications is used to schedule an event, it could be social, religious, commercial or adminis-trative.The main concept is to de�ne periods of time, typically days, weeks, months and years.The calendar can be displayed by Year, Month or Day.Allows creation of commitment scheduled for the whole day or a pre-arranged time.Allows programming and customization of their functionality.

SQL BuilderTool used to help build SQL queries using the wizard concept. Allows you to choose the database, tables, �elds, order by, and, where, and Joins well as for simulations with the option to save the command for your later use.

WebHelpAllows the creation of webhelps in order to standar-dize the documentation and facilitate their creation.Key Features:Allows the creation of �les with HTMLs GUI (WYSIWYG), css, upload images and hierarchical menus.It also allows an application to connect directly to a help page, without the need to edit each application individually.

Data DictionaryUsing Scriptcase's data dictionary, users can create a data repository to use in applications generated. Data associated with the database table �elds is stored to be used in di�erent applications. It is very useful to create an environment with data standardi-zation.It also improves the development, accelerating the data upgrade and minimizing errors.Enables standardization:Data TypesLabelSizeDecimal PrecisionDescription

ADDITIONAL RESOURCESMenu Application

Container Application

Blank Application

Calendar Application

Database Builder:Database Builder allows the Scriptcase user to manage his database or create a new one, it is available in several languages and it can manage any database enabled in Scriptcase. After select a database connection created in the project the user have total control of the database.

Security Module:Making use of ScriptCase security resources allows the implementation of access rules for the system being developed, further decreasing development time of a project, considering that the ScriptCase will generate access applications and all validations automatically.There are three security levels and each level is based on a data model for storing information such as user accounts, passwords, access pro�les, groups, etc. The types are divided in:User - It creates an application based on security for user level. Where the application is linked to user login.

Application - It creates an application based on the application level security. Where the application is related to the user.Group - It creates an application based on security for the Group level. Where is de�ned the access of each group to certain applications.

Log Module:Making use of ScriptCase Log resources you can implement a complete Log system to your projects. Storing all data that was accessed, updated or deleted by the end-user and which applications they are accessing.

Talk to your reseller to check which courses, speci�c trainings and consultancy are available for you.

Don’t forget to ask for your coupon that will guarantee a few bene�ts when you purchase Scriptcase.

ADDITIONAL RESOURCES