icon, right-clicking the table in the Tables in Use panel to display the speed menu from which you choose Select Columns, or by clicking Query>Select Columns from the Menu Bar across the top.
Once the Table dialog window is visible (figure 1), you can add the columns one at a time by pressing the Add button and assign an optional column alias in the Column Alias dialog that appears each time you attempt to add a selected column (figure 2), or you can add all the columns at once by pressing the All Columns button.
(figure 1)
(figure 2)
After the columns have been added, you can reorder them by selecting the column in the Current Selection list and using the Move Up and Move Down buttons respectively. You can also remove any column that has already been selected by using the Remove button.
R:BASE 7.6 also has the ability to use columns from currently selected tables to create expressions as computed columns. To create a computed column using the available columns, press the New Expression button and build your
expression in the Expression Builder dialog (figure 3).
Any existing computed column can be edited by selecting it and pressing the Edit Expression button. Your existing expression will be displayed in the Expression Builder dialog (figure 3).
(figure 3)