Creating Views

If you are already familiar with creating record definitions and writing SQL queries, creating online views is similar.

To create online views:

1. Clone a record definition:

   1. Open an existing record definition.

   2. Select File, and then Save As.

   3. Specify the name of the view that you want to create.

2. Delete and add the appropriate fields.

   All columns that are selected in your view should have a corresponding field in the record definition.

3. Set the record type to SQL View:

   1. Select the Record Type tab for the record definition.

   2. Select SQL View in the Record Type group box.

4. Click the Click to open SQL Editor button.

   The order in which you list the columns in your SQL SELECT statement should match the order that you specified in the record definition. A SQL statement can be given for each platform.

   See Creating SQL View and Dynamic View Select Statements.

5. Save the record definition.

6. Select Build, and then Current Definition to create the view in the database.

7. Select the Create Views check box under Build Options.

8. Click Build.