Add a record to another table from a condition

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 ...