The Insert Statement Dialog

 

 The INSERT statement is opened from the connection dialog by creating a statement on a connection, refer to .

 

The insert dialog is used to insert data into a column or columns of a table of a data source.
After selecting INSERT we notice that all the tables and columns are shown for the datasource of the connection used for this statement. We need to select a table to work with and also a column(s) to insert new data into. (as depicted by 1).

Number (2) allows us to enter the fixed value to insert or the name of a SELECT Statement or the name of a Stored Procedure. We need to double-click in the field to bring up the data-popup. The capabilities of the popup are explained here 

The columns selected for insertion are all updated separately with their respective data sets or static data. If the data used for insertion is not the same size across all the columns then a warning message is logged after the insertion. For example, in the above image we have selected to insert data into all the columns. If all the client-?-select statements return the same number of records then all is well, but if one returns less or more records then depending on the column constraints there will either be a warning or an error logged in the logger. The default behaviour is for db-JAPI to insert all the records of the data set(s) and then produce logs at the end of the processing.