Creating applications from imported database views

You can use imported database views to create applications.

About this task

The unique ID of the main table column cannot be renamed. All other columns can be renamed.

Procedure

  1. Create a view on the database.
  2. In the Database Configuration application, create an object.
    The object name must be the same name as the view created on the database.
  3. In the Extends Object field, ensure that you specify the object name of the unique ID of the main table column.
  4. Create an application from the database view.
  5. If you renamed any fields in the database view, remove these fields from the Advanced Search dialog:
    1. Go to Application Designer and open the new application.
    2. Click Edit Dialogs and select More Search Fields.
    3. Remove any fields that you renamed.