HP 3000 Manuals HP 3000 Manuals
G : Configuring a View Table Now configure a simple view table--PRODUCTS. You'll use the data in Worksheet 3, Figure 2-4. (You'll be using Worksheet 2 in the next exercise, 2:H.) This table renames the items in the IMAGE table PRODUCT-MASTER so PC users can load them into dBASE II. Here's what the system will look like when you add this view table:Figure 2-8. View Table PRODUCTS Renames IMAGE Items ___________________________________________________________ | | | References in this Learning manual: | | Lesson 1:D, How the Data Dictionary is Configured| | Figure 2-4, Worksheet 3 Completed | | | | References in Information Access Server: Database | | Administration: | | Chapter 5, Configuring Tables: | | Adding a View Table Definition | | Appendix B, Constructing View Tables | | Appendix C, View Table Syntax | ___________________________________________________________ Which Items?--------------------------------------------------------------------------------------------- | | | | What You Do | What Happens | | | | --------------------------------------------------------------------------------------------- | | | | G-1. At the Add Table Menu, choose: | The Add View Table screen appears. | | | | | View f1 | Each field on these screens has its | | Table | required syntax. (You'll find the syntax | | | in Chapter 5 and Appendix C of the | | | Information Access Server: Database | | | Administration manual.) | | | | --------------------------------------------------------------------------------------------- | | | | G-2. Type the text shown on the next page | | | in the fields indicated. | | | | | | The Item Clause field is being used to | | | rename IMAGE items to eight characters or | | | less for use with dBASE II on the PC. | | | | | | In the Item Clause field, you can type the | | | items in a continuous string if you like, | | | and text will automatically wrap around. | | | | | | However, it's easiest to correct typing | | | mistakes when you list the items as shown, | | | one item per line. To use a new line, type | | | Return, then v. | | | | | | Be sure to separate items with commas. | | | | | --------------------------------------------------------------------------------------------- ________________________________________________________________________________________ | | | | | Table PRODUCTS Sample Values Security | | | | Table Description PRODUCT VIEW TABLE | | | | Item Clause (separated by commas) | | NUMBER = PRODUCT-NBR, | | PRODUCT = PROD-DESCRIPT, | | VENDOR = VENDOR-NAME, | | TYPE = PRODUCT-TYPE, | | UNITCOST = UNIT-COST, | | PRICE, | | NOTES = PROD-NOTES | | | | | | | | | | | | | | | | | | | ________________________________________________________________________________________ --------------------------------------------------------------------------------------------- | | | | G-3. Proofread the information you've | As was true for IMAGE tables, when view | | typed and when you're sure it's correct, | tables are defined, more fields are | | choose: | required than will fit on one screen | | | display. When you choose Next Fields f3, | | Next f3 | additional fields appear. | | Fields | | | | | --------------------------------------------------------------------------------------------- Using What Table as Source? --------------------------------------------------------------------------------------------- | | | | What You Do | What Happens | | | | --------------------------------------------------------------------------------------------- | | | | Indicate what previously configured | | | table(s) to use as the source of the item | | | just defined. | | | | | | G-4. Type PRODUCT-MASTER in the Using | This tells the Administrator Utility to | | Clause field. | look in the table PRODUCT-MASTER to find | | | the items. The Using Clause must always be | | | filled in so Access Server will know where | | | to go when it constructs this view table. | | | | | You could also define operators to limit | | | which records to include (the Where Clause) | | | and a sort order for the records (the Sort | | | Clause). | | | | | | However, because you want to include all | | | records in their default order, the Using | | | Clause is all you need. | | | | | --------------------------------------------------------------------------------------------- | | | | G-5. To configure the view table, press | The screen clears and displays the first | | Enter. | group of Add View Table fields. Your entry | | | has been accepted. | | (If you made a syntax error when typing in | | | the Item Clause, an error message appears | You have told the Administrator Utility to | | and the cursor goes to the field with the | draw the items you specified from all | | error. Correct your mistake and press | records included in the table | | Enter.) | PRODUCT-MASTER, in default order. The | | | items will be renamed for use with dBASE | | | II. | | | | --------------------------------------------------------------------------------------------- | | | | G-6. To get ready for the next task, | The Add Table Menu appears. You have | | return to the previous menu by choosing: | successfully added a simple view table. | | | (You'll define a complex table in Lesson | | Cancel f8 | 5.) | | Add | | | | You are in position to go directly into the | | | next task by using the Go to screen field. | | | | --------------------------------------------------------------------------------------------- What This Table Will Look Like Here is what the view table PRODUCTS will look like when it is displayed using Access PC:Figure 2-9. PC Display of View Table PRODUCTS Summary In this exercise, you learned how to: * Specify view table items that derive from one IMAGE table. * Rename IMAGE items for use with dBASE II on a PC.
![[]](../../pic3k/M012040/FFN303c50.gif)
![[]](../../pic3k/M012040/FFN323c50.gif)
![[]](../../pic3k/M012040/FFN343c50.gif)
![[]](../../pic3k/M012040/FFN353c50.gif)