How to add new columns from DB table to FM

[swarupa]

Few new columns have been added to existing DB table.
also DB is migrated to new version with all passwords is same as old DB.

Can anyone let me know step by step process to add new columns into FM? I have three Layers DB Layer, Business Layer and Presentation layer in FM..

[bdbits]

If you used "select *" star on the db layer, just update the query subject from the FM menus and the columns should appear. If you used specific SQL columns, you will have to modify the query subject yourself. In either case, get them added to the db layer as your first step.

Business/presentation layers should be selecting from the database layer, so once the above is done you should be able to select them like any other column you selected on those layers.