Creating an Insert Database Operation Call

If you selected the Insert database operation, the wizard opens the Insert Operation main page and displays information from the table or business view that you selected. The Insert operation main page has only one tab, Insert Columns.

The Insert Columns tab shows all of the columns that are available in the table (business view) that you selected. Each column from the table (business view) is displayed as a row and includes the column name, description of the column, column type, and column length, and indicates whether the column is a primary key. You can sort the rows by clicking in a column header. For example, when you click the Column Name header, you can sort the rows in ascending, descending, or default order by column name. You can sort by any one of the column headers.

From the table or business view, you select the columns that you want to use in your Insert database operation. You can select specific columns by selecting the check box in the appropriate row, or you can select all of the columns by clicking the Select All button. If you did not select all columns, you can select the Display Selected Only option to show only those columns that you selected for your Insert operation. You can clear all of your selections by clicking the Clear all button.

After you select the columns you want to use in your Insert database operation, click Next to see a preview page. The preview page shows a conceptual SQL statement. You can use the Back button to return to a previous page and select or clear columns from the table or business view. When you are satisfied with your selections, click Finish. The wizard creates an Insert database operation call where your cursor is located, and it produces accompanying code. You must modify the Insert call to include the appropriate value objects and you should review the generated code and update as necessary.