Replace scriptcase icon code#
So if by chance you deleted an application inadvertently or even on purpose, but remembered that you need a code on that deleted application, just use this to restore that application. One of the best options disposed by Scriptcase, on this option we can restore deleted applications. To do that, all you need is to do is select the connection, the desired tables, mark the two options (Form and Query) and click “Next”. We have the option to create application by application and we have the “batch applications” option that will create the two applications together (query and form), this option will create the two types of applications already with the connection between them to be able to edit the record. So let’s imagine the following situation: We have a supermarket system, in this system I will need to register and call in: categories, products, payment methods, customers, suppliers, etc … In order to record we use the form type application, and to call in we use the grid type application.
Replace scriptcase icon how to#
I believe most of you guys already know this option but you might not know how to use it correctly. Saved: You can save your query to use it on another occasion. You can also mount the grid directly on the execution tab without having to go through all the tabs. Sorting: If you want to sort some field, for example ordering date from the most current to the oldest.Įxecution: At last the execution of your grid, able to display a maximum of 100 records. įields: In this tab you choose the fields you want to view in the query, you can still add an alias to your table, this alias is most often used when searching in more than one table.Ĭonditions : Just define the conditions of your query, in this case the WHERE clause. Tables: In this tab you must select one or more tables that you want to search.
I will explain each grid situation as example.ĭatabases: In the database section you will choose which connection you want to use, because your project may have more than one connection. We can observe some tabs: Databases, Tables, Fields, Conditions, Ordination, Execution, Saved. The SQL Builder allows us to edit more than one database, it allows us to perform searches between one or more tables, it allows us to test grids before going inside the applications.
If you’re a developer you probably know many tools that can be used to perform searches and modifications on the databases, for example the Workbench, for those who use MySQL database or the SQL Server Management Studio, for those who use SQL Server database.These tools will ease all the work with codes related to databases, although Scriptcase provides the option called “ SQL Builder “. On today’s post we will continue with those suggestions, i hope you enjoy. Multiple Record: It will show as many records as you want and you can edit then all at the same time using a single button.Hello! On the latest post i’ve shown some hints on facilitators for developers.Single record: Only one record per page.You can divide the form’s field in blocks, tabs, set the label to be show on the side of the field’s input or on the top of it. We created one of the most complete “format as you type” feature for the fields, together with a field’s mask option we can do pretty much cover all you needs on the data shown option.
Replace scriptcase icon update#
You can make changes on Scriptcase’s form fields that you were not able to do directly in the database for some reason, for example, if you want to set a field to auto increment even if is not set in the database, you can force specific values for update and/or delete, set it as a unique key all using only Scriptcase, without the need of changing anything on the database.Īll the CRUD (Create, Read, Update and Delete) database actions are created automatically independent from the database or operating system, the forms also have full protection against SQL and JavaScript injection in all field’s inputs and also directly on the edit HTML code option. Scriptcase will read your database, understand the fields’ type, relationships, dependencies, keys, tables’ structures and special characteristics to create a form based on it. As a PHP RAD (Rapid Application Development) tool, Scriptcase will help you to reduce the form creation time up to 80%, it will allow you to have a full function, secure and complete form with just a few clicks.
0 kommentar(er)
