Prices start from 400$ per year for the 'starter' version and reach 1.400$ for a lifetime 'enterprise' package or 650$ per developer which supports more database products. The pricing model includes yearly subscriptions as well as lifetime options. Since then, it has been receiving regular updates.
The package also includes a documentation generator that can integrate the developer team. For example: if the field is defined in the database as cmpnameclient, it will be more clear for the comprehension of the user if the name would be Client Name. Search Label : Defines the title of a field in the application. Tabs in forms allow to group form pages or queries on the same page. When set to Check box, your allowed to have multiple options selected. It is also possible to create infrastructure such as menus, login screens and a security system with authentication. Scriptcase allows users to write PHP code to handle exceptions and create more complex validation. Complex SQL statements can be used like sub-selects, joins and stored procedures.
Report output can be exported to MS Word, MS Excel, PDF or printed.
The software facilitates development with JavaScript and allows to create applications with AJAX through a set of features and services, such as navigation between pages or sections, or automatic validation of fields. It allows to create forms and queries, ranging from simple forms to a high level of complex elements to manipulate data from databases like MySQL, PostgreSQL, SQLite, Interbase, Firebird, Access, Oracle, MS SQLServer, IBM Db2, SyBase, Informix and ODBC connections.
Scriptcase can be used as a mere CRUD (Create, Read, Update and Delete) tool for given database tables, but also enables custom code to manage business rules and validation. In difference to PHP frameworks, after deployment the development software is no longer necessary to run the application. The development as well as runtime environment use a webserver like Apache, PHP and an SQL database. The software was developed by NetMake in 2000 and can be used on Mac, Windows, and Linux operating systems. Developers use a graphical interface to design and generate code. 1 In this example, we will use 4 applications: A Grid using the order table, an order form, a second form, of the editable grid type, with the order items. It is web oriented and can be installed on an intranet or internet server. Check that the fields which were on blank situation, are now filled with chosen values.Scriptcase is a Rapid application development platform that works as a code generator for PHP web applications, and is based on the same script language. When you’ve been redirected to grid’s application choose one register to use, clicking on “Insert”.Ĭ. It is possible to see that the fields are blank. Still on onLoad event lets populate the fields with the variables sent by grid’s URL.Ī. On the onLoad event use the code below to redirect to the grid’s application. On the onApplicationInit event we are going to use the macro sc_apl_conf(‘form_vendas’,’start’,’new’) to force the form to start in the inclusion mode. Creating a virtual field as Label, called “link” On form’s application let’s create a virtual field to redirect to grid’s application.
This way we’ve created variables called “name” and “email”Ĭ. On the onRecord event we will define the field with form application’s path concatenating with the variables that will be sent. Create a field, called “link”, to be used as link to redirect you to the form application with parameters. On grid applicaitons lets define the parameters that will be sent by URL. We are going to create a form application for Sales and a grid appliation for Users.ī. Step #2 – Creating and Configuring the applications:Ī. To do so, we will send the parameters by URL using the $_GET array.
Using $_GET on Scriptcase: On this tutorial we are going to show how to create a form application that will use a grid application to automatically fill form’s fields using only programming to pass parameters between applications.