Note: If a table is created from a DW_ procedure, the order of the columns cannot be modified. Also, the order of the constituent columns of the LOC_IDENT column is set in the Setup LRMs window.
The columns in the data window for a data table appear in the order specified in the Order column of the Data Window tab of the General Object Properties. Number 1 signifies the leftmost column and then increments to the right. To change the order in which the columns appear in a window, use the following steps:
- Use the steps in Update Window Using Design Mode to activate design mode.
- Open the Tables window.
- Right-click the record for the table that contains the columns to be re-ordered and then click Change Control Properties. The application displays the User Control Properties dialog box.
- Click the Data Window tab.
- In the lower pane of the tab, modify the values in the Order column to indicate the desired order.
- Select OK to close the dialog box.
- Click the
icon. The application asks if you wish to save the new layout. - Select OK to save the new layout.
- Exit Design Mode by selecting the Settings menu to display the Design Mode switch and then click the switch to set it to off.
