Creating a View from Any Object

Using a single query, you can create a database view from any object.

In a similar way to creating a view from a scorecard, you can create a database view from any object. Depending on the object type, you will use a different procedure name.

• To create a view from a form, use PS_ADD_FORM_RV.
• To create a view from a map, use PS_ADD_MAP_RV.
• To create a view from a scorecard, use PS_ADD_SCORECARD_RV.
• To create a view from a tab, use PS_ADD_FORM_TAB_RV.

1. In Query Analyzer, type the following command:

   PS_ADD_<ObjectType>_RV '<ObjectName>', '<ViewName>', '<ViewDescription>'

   Where:

   • '<ObjectName>' is the Object Name.
   • '<ViewName>' is the database view name.
   • '<ViewDescription>' is the description. You can use null if you do not want to provide a description for the view.
2. Click Run.