Add rows to a database table

---

This adds a new row of data to the database table, using an INSERT statement. The method of creating an Insert Rows command is very similar to the Select Data command. First a Table must be chosen, then columns. At this point Simplicity generates sample SQL code with dummy values inserted. These values may be edited, or set up in the UI Mapping tool to be replaced with user values. Note that a query must be executed once before UI Mapping can be done on it.

Modify rows in a database table

This option is used to change data in existing rows in a table, using an UPDATE statement. First a table must be chosen, then the column(s) to modify. Finally, rows which meet the given criteria are chosen, generating a WHERE clause. See "Search only for rows that have the following criteria" on page 86 for more information. Simplicity generates sample SQL code with dummy values inserted. These values may be edited, or set up in the UI Mapping tool to be replaced with user values. Note that a query must be executed once before UI Mapping can be done on it.

Delete rows from a database table

This option is used to delete a row or set of rows from a database table, using a DELETE statement. First a table must be chosen, then rows which meet the given critera are chosen, generating a WHERE clause. See page 86 for more details. Note that a query must be executed once before UI Mapping can be done on it.