Select Columns Tab

The Select Columns tab shows all of the columns that are available in the table or 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, and column type, and indicates whether the column is a primary key. You can sort the rows by clicking in any of the column headers. For example, when you click the column header Column Name, you can sort the rows in ascending, descending, or default order by column name.

From the table (business view), you select the columns that you want to use in your Select 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 those columns that you selected. You can clear all of your selections by clicking the Clear All button.

The Fetch All Records option and Select Distinct option are used by the system at runtime. The Fetch All Records option works with tables and business views and fetches all records that meet the search criteria. The Select Distinct option works with both tables and business views, but is more commonly used with business views. When many records meet the search criteria, you can use the Select Distinct option to select only one record for the search criteria instead of selecting all of the records. If you do not select this option, then the system returns all occurrences of these records, including all detail lines.