Add a record to another table from a condition
1- We create a form where we will perform the validation.
2- In the OnValidate event of our form we introduce the code with this scheme
if (condition == condition)
{
insert the data to the other table;
} else {
echo "no records added";
}
3- this will proceed to add the record in our other table of our database
Related Articles
Creating a field that verifies values in another table
In this tutorial, we will see how use a field with type “Select” to checks values that are in another tables. For example, we are using two tables: “states”(that will include the values to be checked) and “city” (that will receive the values that are ...
Adding new columns in the table for Calendar
If your calendar application is already created, we must add the fields below in the table so that the new functionalities work correctly: category int id_api varchar(255) id_event_google varchar(255) recur_info varchar(255) event_color varchar(255) ...
Update a widget based on another widget.
1-) Create a Grid (product table), whose configuration is Grid Modules → Orientation to Slide Configuration → Columns per pages: 5 Link between Applications → Link to a blank application that will perform the update, where the link will ...
How to add themes to an existing project
In the project creation process, we must select the themes that will be part of the project. If you want to add new themes to previously created projects, follow the step by step below. Adding theme to the project 1 - First, add the new theme within ...
How to change the log module table
After creating the Scriptcase log module, it is possible to change the table. When making this change, a new table will be created from scratch with no records. The records in the previous table must be migrated to your database. How to edit log ...