Microsoft KB Archive/115589

INF: Overview of Catalog Manager

PSS ID Number: Q115589 Article last modified on 06-01-1994

2.60 | 2.60 WINDOWS | MS-DOS

= SUMMARY =

The information below describes Catalog Manager, which is a new tool in FoxPro 2.6. This information is also found in FoxPro 2.6 Help. To locate this Help file topic, do one of the following: - If you are using the Windows-style Help file (FOXHELP.HLP), choose dBASE Help from the Help menu. -or- - If you are using the DBF-style Help file (FOXHELP.DBF), go to the Catalog Manager topic under the “The FoxPro Interface” section.

= MORE INFORMATION =

The FoxPro Catalog Manager is a graphical interface that enables you to manage catalogs (.FPC or .CAT files) easily. Catalogs can contain tables, queries, screens, reports, labels and programs. From this central location, you can create, modify, and run these FoxPro files. You can also use AutoMigrate to convert existing dBASE III and dBASE IV files. The Catalog Manager, written entirely in FoxPro, is an example of the type of application you can develop in FoxPro. Catalog Manager Menus The Catalog Manager menus are: File, Edit, View, Data, Tools, Window, Help. Catalog Manager Window The Catalog Manager window displays the contents of a catalog and allows you to add, create and modify tables, queries, screens, reports, labels and programs. You can also use, run or print files as applicable. You use the Table, Query, Screen, Report, Label and Program tabs to choose the type of files to display in the scrollable list. When you click on a tab to choose it, that tab becomes the active tab. FoxPro displays the files in the current catalog that match the active tab, and changes the push buttons to the right of the file list so they match the tasks you can accomplish using the tab. For example, when you choose the Table tab, FoxPro shows the tables (.DBF files) in the current catalog, and displays the Add, New, Modify, and Use push buttons. If you select the Screen tab, the Use button changes to Run. You can also run a file in any tab by double-clicking the file in the file list. You can choose a different tab by clicking on it or using the View Menu. To view a different catalog, select Open Catalog from the File menu. Picture buttons located above the tabs provide access to the active table, the AutoScreen and AutoReport features, and FoxPro Help.

Buttons
Browse - Displays the active table/query in a Browse window. Disabled when the current catalog contains no tables, or no table is in use. AutoScreen - Creates and runs a new screen based on the active table/query using the Screen Wizard default settings. Disabled when no table is in use. AutoReport - Creates and runs a new report based on the active table/query using the Report Wizard default settings. Disabled when no table is in use. Help - Opens the FoxPro Help window to the Catalog Manager topic. Always available. Active Table/Query The Active Table/Query line just above the Catalog Manager tabs displays the name of the table or query currently in use. FoxPro bases all the new files you create on the active table or query. To make a table or query active, choose the appropriate (table or query) tab, select the file you want to use, and choose the Use button in the Catalog Manager. The table or query name then appears in the Active Table/Query line. Description The Description line just below the file name list box in the Catalog Manager displays the file description for the selected table, query, screen, report, label or program file. To change the description, see the File Description Dialog Help topic. Data Source When the Screen, Report or Label tab is active, a Data Source line displays the source file for the selected screen, report or label file. If you want to view the description for the source file, select the appropriate (table or query) tab, then select the source file in the file list. FoxPro catalogs are single-user files. If you run more than one concurrent session of FoxPro, each session must have a local copy of the FOXUSER resource file. You can add table, query, screen, report, label and program files to more than one catalog.

Creating a Catalog
You can create a new catalog from the File menu. To create a catalog from the File menu: 1. From the File menu, choose New Catalog… FoxPro displays the Save As dialog. 2. Type the name of the new catalog file in the Save Catalog As text box. Choose Save. The Catalog Manager window appears, displaying an empty catalog file. You can then add existing table, query, screen, report, label and program files to your catalog, or create new files. For more information on adding files to a catalog, see Editing a Catalog in this topic.

Editing a Catalog
Editing a catalog is different from adding or removing files on your system. To add a file to a catalog you specify the name of a file that already exists on your system; FoxPro then adds the file name and file location to your catalog (.FPC) file. When you remove a file from a catalog, FoxPro removes the file name and file location from your catalog file. The actual table, query, screen, report or program file remains on your system, unless you also choose to delete the file. You can add a file to your catalog using a tab or the File menu. To add a file to the active catalog using a tab: 1. Select the tab representing the type of file (table, query, screen, report, label, or program) you want to add to your catalog. 2. Choose the Add push button. FoxPro displays the Open dialog. 3. Select the file you want to add to the catalog from the list of filenames. Use the Drives and Directories list to locate the file if it’s not in the current directory. 4. Choose Add. FoxPro adds the name and location of the selected file to the active catalog (.FPC file) and displays the filename in the file list for the selected tab. To add a file to your catalog using the File menu: 1. From the File menu, choose Add File… to display a cascading menu of the types of files you can add to a catalog. 2. Select the file type for the file you want to add and click or press Enter to display the Open Dialog. 3. In the Open dialog, double-click on the file you want to add to the catalog. You can remove a file from your catalog using the Delete key or the File menu. To remove a file from the active catalog - Select the file in the file list, then press the Delete key, or choose Remove File… from the File menu. FoxPro displays the Remove File dialog.

Switching Between the Catalog Manager and FoxPro
You can switch between the Catalog Manager and FoxPro at any time. To switch from the Catalog Manager to the FoxPro menu system and Command window: - From the File menu, choose Command Window. The Catalog Manager closes and FoxPro displays the main FoxPro window and Command window. To switch from the FoxPro menu system and Command window to the Catalog Manager: - From the File menu, choose Catalog Manager… The Catalog Manager opens, displaying the last catalog used. If there is no catalog to open, a dialog prompts you to open an existing catalog or create a new one.

Opening an Existing Catalog
FoxPro opens the last opened catalog when you choose the option Proceed to the Catalog Manager from the Introductory Screen. If it is not possible to determine the last opened catalog, FoxPro displays the Open dialog. Once in the Catalog Manager, you can also open a different existing catalog (dBASE .CAT file, or FoxPro .FPC file) from the File menu. To open a catalog from the Catalog Manager: 1. From the File menu, choose Open Catalog…. FoxPro displays the Open dialog. 2. Select the catalog you want to open from the list of files. 3. Choose Open.

Removing a Catalog
You remove a catalog by deleting the catalog files from your system. FoxPro catalogs consist of two associated files. The catalog file has the extension .FPC; the associated memo file has the same name as the catalog, with an .FCT extension. dBASE catalogs have the file extension .CAT. Deleting catalog (.FPC and .FCT, or .CAT) files from your system does not affect the table, query, screen, report, label and program files referenced within the catalog. The referenced files remain on your system until you choose to remove them. If you want to remove from your system both the files referenced in a catalog and the catalog itself, first edit the catalog to remove the file references. Check the Delete File from Disk check box in the Remove File dialog to delete the actual files. You can then remove the catalog file from your system. For more information about editing a catalog, see the Editing a Catalog topic.

Exiting the Catalog Manager
When you exit the Catalog Manager you can choose to work in the main FoxPro window or to quit FoxPro. To work in the main FoxPro window: - From the File menu, choose Command Window. The Catalog Manager closes and FoxPro displays the main FoxPro window and Command window. To quit FoxPro - From the File menu, choose Quit. The Catalog Manager closes and FoxPro closes.

Configuring the Catalog Manager
The Introductory Screen is displayed by default when you enter FoxPro. If you do not want to display the Introductory Screen each time you start FoxPro, you can check the Don’t display this Introductory Screen again check box. If you’ve checked this check box in the past and want to see the Introductory Screen again, or if you want to start the Catalog Manager automatically when you enter FoxPro, edit your CONFIG.FPW file. To display the introductory screen again, remove the CATMAN=ON/OFF entry. If each time you enter FoxPro you want to display the Introductory Screen, edit CONFIG.FPW to include [no CATMAN entry]. If each time you enter FoxPro you want to suppress display of the Introductory Screen and enter Catalog Manager, edit CONFIG.FPW to include CATMAN=ON. If each time you enter FoxPro you want to suppress display of the Introductory Screen, bypass the Catalog Manager and display the FoxPro Command window, edit CONFIG.FPW to include CATMAN=OFF.

= Additional reference words: 2.60 foxhelp.dbf foxhelp.hlp =

Copyright Microsoft Corporation 1994.