Creating and Using Files with the .FPC Extension

ID: Q114855 

2.60    | 2.60
WINDOWS | MS-DOS kbprg

The information in this article applies to:

SUMMARY

The Catalog Manager stores information about the currently selected catalog in a "catalog file." A catalog file is an ordinary .DBF file with an .FPC extension. The default file extension for the file containing memo fields associated with a catalog file is .FCT. The default file extension for a file containing memo fields associated with a typical .DBF file is .FPT.

MORE INFORMATION

To support the concept of a catalog file, certain changes were made to the USE command and to the CREATE TABLE command. If you CREATE an .FPC file and the file has one or more memo fields, the associated memo file will be created with an extension of .FCT.

For example, the following code will produce two files named TEST.FPC and TEST.FCT: 

   CREATE TABLE test.fpc (one C(2), two M)
By contrast, the following code will produce two files named TEST.DBF and TEST.FPT: 

   CREATE TABLE test.dbf (one C(2), two M)
If the extension of the file is anything other than .FPC and the file contains a memo field, the associated file will have an extension of .FPT. The .FCT extension is created only when the table has an extension of .FPC.

The USE command has also been modified to support .FPC files. If a database file ending with an .FPC extension is USEd, and that database file has a memo field, the USE command will search for a memo file with an .FCT extension. If the USE command is issued to use a database file that does not have an .FPC extension and the database file has a memo field, the USE command will search for a memo file with a standard .FPT extension.

Additional reference words: FoxDos FoxWin 2.60 KBCategory: kbprg KBSubcategory: FxtoolCatman 

Keywords          : FxtoolCatman 
Version           : 2.60    | 2.60
Platform          : MS-DOS WINDOWS

Last Reviewed: May 1, 1996