How To - Add a column to an existing table window

This section describes how you customize an existing form window by adding a cColumn to it.

The example is using the steps described in A Simple Client Customization as base, followed by additional steps for adding the column.

Pre-Requirements

A Simple Client Customization getting a customized form window named tbwCustomerInfoOverview_Cust.

Note: Customize the tbwCustomerInfoOverview table window instead of frmPersonInfo form window which is used for example above

Add the column

• Open tbwCustomerInfoOverview_Cust in Designer mode.
• Open the Toolbar menu IFS Development Tools and start the Dataset Toolbox
• In the Dataset Toolbox, press the Refresh View Info button and logon to the database
• Drag one of the fields from the list into the designer area or tbwCustomerInfoOverview_Cust
• Compile and start IEE
• Open the customized window named Customers

Example: Shows how column ''One-Time Customer'' is dragged from the Dataset Toolbox into the Design area of tbwCustomerInfoOverview_Cust

Result

Your column should now be available on the customized table window.

Tips

You might encounter having added a column like in the example above, placing it between two other columns e.g. 'Identity' and 'Name' but when run, getting the column placed at the very end on the table window. This is probably due to having run the original table window earlier having it stored the column order in the personal profile. Now when a new column in added, the personal profile gets 'updated' by placing all new columns at the end.
Solution: Ensure to 'Reset Current View' for the table window making the columns be shown in the same order as in design time.