Use the SQLAssist SmartGuide to visually compose an SQL INSERT, UPDATE, or DELETE for a Modify bean.
Using the SQLAssist SmartGuide you can:
You must first chose the statement type. Chose the Insert button if you want insert data into the database. Chose the Update button if you want to update rows in the database. Chose the Delete button if you want to delete rows in the database.
When you display the SQL INSERT, UPDATE, or DELETE, you can also run it as a test using the SQL Assist SmartGuide. You can also copy the SQL statement to the clipboard or save it.
Specifying the tables for an SQL statement
Specifying columns and their values for an SQL UPDATE or INSERT
Specifying search conditions
Displaying the SQL statement