Add a database field to an existing record

You have created the data model (.4rdj) file using the Report Data From Database wizard, but you now need to add more fields from the database.

There are several methods for adding a database field to an existing record. After adding the columns, you must rebuild the business record (.4rdj).

From the DB Schemas view, find the column you wish to add to the record. Use drag-and-drop to place it on the record, in either the Document View or the Structure View.

Tip:

This is the quickest method for adding a database column to an existing data model record.

In the Document View or the Structure View, right-click on the record and select Add Field from the contextual menu. Click on the new field and use the Properties view to specify a new name (the name property), and use the properties in the Field section to specify the database details (fieldType as TABLE_COLUMN, sqlTabName for the table name, and colName for the column name).