Update SQL

The objective of this guide is to demonstrate how to configure an Update Button that updates records in a database using SQL queries.

Expected output:

1st Step

  1. Add a blank transaction form to start.

2nd Step

  1. Add the fields in the form that you want to update. For example, if you want to update the Full Name field, add it to the form. Then, include a button labeled "Update" to trigger the data update process when clicked.

3rd Step

  1. Set the Button Type to Submit. Then, customize the design of the button to match your requirements, such as adjusting the color, size, and text to fit the style of your application.

4th Step

  1. In the Action Tab, go to the API Section. First, set the Primary Key, as this key will be used to identify the record that needs to be updated.In the Create Section, configure the Data Source, Database, and Model. Next, in the Update Section, configure the Data Source, Database, and Model as well. Select the Operation as Update to modify the record. Add the necessary query parameters for the update operation; in this example, we are adding the primaryKey and primaryValue parameters.Also, set the Response Attribute to handle the response after the update is completed.In this example, we are using RDBMS as the data source and MS SQL as the database. However, you can configure these settings based on your specific data source and database.

5th Step

  1. Save the configuration. Your setup is now complete, and you can begin updating records.

Final Output: