Before using View Manager, you must define your files with DB Manager.
There are three ways to start the View Manager:
The View Manager screen is displayed. Notice the buttons on the left and the tabs on the right.
- From Comet Data Express, click the "View Manager" button.
- From the READY prompt, type VIEWMGR and press Enter.
- From the Comet Utility Programs menu, select number 25.
The following options are available:
- New View
- Copy View
- Crystal Reports
The following tabs are available:
- Primary File
To create a new view, click the "New View" button. A dialog is displayed and you are asked to provide the following information:
1. Enter a name for you new table
Type a descriptive name for the new view you are creating. This value may be up to 30 characters long.
2. And a directory where it will be created
Choose the Comet directory where the view will be created.
3. Select the primary file
Click on the name of the primary data file you will be using in this view.
Note: The data files contained in this list must be defined with the DB Manager utility program.
Click the "OK" button.
Optionally, you can enter a descriptive title for the view you are creating.
Information about the primary file is displayed in the four tabs on the right side of the dialog. The tabs are:
1. Primary File
This tab displays the name of the primary file, and prompts for a key range and sort fields. Both of these features are optional.
If you specify a starting and ending key ("from this key" and "to this key," respectively),
the view will process only those records in the specified range. For a large data file,
this can save a lot of time, as View Manager only needs to read records in the range you’ve chosen.
You may also specify one or more sort fields. You do this by clicking on the field name in the left column,
and then clicking the "Add" button, or by double-clicking on the field name in the left column.
Doing so displays the sort field in the right column. For each sort field, you may specify ascending or
If you have multiple sort fields, you may change their order by using the "Up" and "Down" buttons.
To remove a sort field, click on the field name in the right column, and then click the "Remove" button,
or double click on the field name in the right column. The field name is redisplayed in the left column.
This tab displays the file linkages that area available for the primary file.
A file linkage provides View Manager with a way to retrieve data from files that are related to the primary file.
The available links are shown at the bottom of the screen. To choose a link, click on the link name,
and then click the "Add" button. The linkage is displayed at the top of the screen.
To remove a link from the view, click on the link name on the top part of the screen,
and then click the "Remove" button.
This tab displays the fields that are available for this view. These fields include fields from the
primary file and all linked files. The format includes both the file name and field name for each field.
For example, suppose you chose a file named CUSTOMER and it contained a field named CUST.NUM.
The display would show the following name:
To add a field to the view, select the field from the left column, and then click the "Add" button,
or double click the field in the left column. The field is displayed in the right column.
If you have multiple fields, you may change their order by using the "Up" and "Down" buttons.
To remove a field from the view, select the file in the right column, and then click the "Remove" button,
or double click the field in the right column.
This tab displays the selection criteria for this view. Start the process by clicking on a field name.
Then choose the desired operator:
- EQ - equal to
- NE - not equal to
- LT - less than
- GT - greater than
- GE - greater than or equal to
- LE - less than or equal to
To compare the field to a constant value, click the "Constant value" button.
A dialog is displayed that allows to you enter a comparison amount. If this amount is a string field,
it must be surrounded in matching quotation marks.
To compare the field to another field, click on the "SELECTING IF" statement.
A dialog is displayed that allows you to edit the selection clause.
Type the field name to be compared, and then click the "OK" button.
If you have more than one selection criterion, click the "AND" or "OR" button, as appropriate,
and then repeat the steps necessary to specify the additional criterion.
Each step in the selection process is displayed on the bottom portion of the screen.
To edit the selection criteria, double click on the line you want to edit.
A dialog is displayed that shows the SELECTING IF command, and allows you to edit this command as necessary.
When you are done editing, click the "OK" button.
There are two additional buttons that allow you to edit the selection criteria.
The "Undo" button removes the most recently completed selection parameter,
while the "Remove" button eliminates the entire line.
To create a report using Crystal Reports, click the "Crystal Reports" button. Enter a name and
directory for your report and click the "OK" button. Proceed to design your report in Crystal Reports.
To export your data to an Excel spreadsheet, simply click the "Excel" button. View Manager examines the
information in your view, and then proceeds to export the data from your Comet data file(s) directly to an
To edit an existing view, select the view name on the left portion of the screen.
Information about the view is displayed in the four tabs on the right side of the screen.
Edit the view properties and necessary, and then click the "Apply" button to save your changes.
To copy an existing view, select the view name on the left portion of the screen, and then click the "Copy View" button. Type a name for the copied view, and then click the "OK" button. Finally, click the "Apply" button to save the copied view. (Note: The copied view will be saved in the same directory as the original view.)
To delete an existing view, select the view name from the list of views, and then click the "Delete" button.