![]() problem with the date field being changed to varchar, when a grid has a special SELECT (INNER JOIN, SUBSELECT, etc.) in Firebird problem with the "Close form after updating or adding" options and editing link. ![]() ![]() field auto-completion problem when associating tables when creating a security module with Oracle, SQL Server and Postgres connections problem in the configuration of the columns option when using grouped fields problem with sorting special conditions in date-type field filters in grid applications problem when selecting records in refined search after performing an advanced search in a query application with Firebird connection problem with sorting for display in break fields with lookup problem with case-sensitive sorting in break fields problem in record insertion when using automatic auto-increment with sequence in MariaDB connections All the tools you need are available in a single, extensible platform, which runs as a part of the Script case environment. Much of the development process is managed for you: security, authentication, database interactions, input validation, session state management, and many other dependencies work out of the box. With the app, you can focus on the problem at hand. The tool offers some additional tools to support your project development, such as: Data Dictionary, Database and Queries Manager, Documentation Manager, wizard for applications creation, Macros with useful PHP functions, ready-to-use codes and Libraries Manager for you to create a code repository. Manage your versions and keep a history of changes, enabling new versions created with the same design, using a native versioning resource offered by the software. This app for PC evolves continuously with the major technological market innovations. Keep your projects in a continual improvement process. This means your application does not require the program to run in production. The generated applications, use PHP, HTML, CSS, and JavaScript technologies. Requiring only a web server with PHP support. With just one click the application source code is generated and displayed with all modifications carried out, allowing a quick preview and test of the final application.ĭeployment is the process you use to make applications, developed within the app, available to be accessed by the end-user. You can change everything from the way one button looks to the entire theme of the app, with a few points and clicks. Use the Business intelligence concept to build management dashboards.Ĭhoose from pre-designed screens or create our ownĬustomize your Application's UI without writing a single line of CSS or Javascript. Use the modern, intuitive, and powerful browser-based environment to quickly build and run web apps such as forms, reports, charts, PDF, dashboards and menus, enabling easy iterative development. Make the data access and maintenance an uncomplicated step! Convert XLS and CSV files type into database tables to create apps and reports. A powerful PHP generator for you to develop fast, simple, secure, and at a low cost.Ĭonnect with your database ( MySQL, PostgreSQL, SQLite, Interbase, Firebird, Access, Oracle, MS SQLServer, DB2, Sybase, Informix, or ODBC layer) and generate web applications based on your tables in a simple and safe way. Scriptcase for Windows enables you to design, develop, and deploy beautiful, responsive, database-driven applications using only your web browser. Data Processing in Control Forms: Using Macros to query and insert into Databaseĭata processing can be done at the Database level (with Stored Procedures, Triggers, Functions and so on) or Application level.Go from prototype to production, in a few steps Depending on how big the volume of data to handle are and the interaction that the user must have, one or the other may stand as the best option in some cases. ![]() The data processing that we will show as an example here is the one done at the Application level, to execute this example we will take certain parameters from the Database. On the other hand the user will enter some parameters and then complete the calculation and insert the result into the Database. In terms of Database structure, we have two tables which are shown below: We will use the following Scriptcase Macros to make our work easier: The table “Parameter” in a PostgreSQL database. The process that we will do will calculate the percentage of interest that the user will have to pay based on the amount desired and the number of installments (months) that he needs to pay back. Within the table “Parameter” we have the percentage of interest that the user will pay based on the number of months that he chooses in our application. Once inside our project in the Scriptcase, we create the connections that we will need to consult the table in PostgreSQL (conn_Parameter) and then insert into the MySQL table (conn Sales).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |