Click above to get retro games delivered to your door ever month!

  DBFINFO.EXE:

  The DBFINFO utility will display the following information about a
  database file:

    .  Last Update
    .  Data Offset
    .  Record Size
    .  Number of Records
    .  Number of Fields
  * .  Memo Type   (None, DBT, FPT, SMT, FlexFile, or Unknown)
    .  Structure

  (*) - If an FPT or SMT memo file is being used, the memo-block size in
        use will also be displayed.

  If the data file is encrypted, DBFINFO will display the string [Encrypted]
  beside the database file name.

  DBFINFO will attempt to verify the integrity of the data/memo file headers
  and, if any corruptions are detected, will alert you to them.  Running
  DBFINFO with the /f option will attempt to correct the header corruption
  This modifies the file directly, so you should make sure you have a backup
  of the file before using this switch.

  DBFINFO will also optionally create a CA-Clipper .PRG file which contains
  the source code for creating the specified database file, including any
  associated memo file of the proper type and memo-block size.

  The command-line syntax for using DBFINFO.EXE is as follows:

    DBFINFO <DBFname>[.DBF] [Options]

    Where:  <DBFname> = The name of the database file to be processed.

    Options: /e = Check for and correct extra EOF markers.

             /f = Attempt to fix any detected header corruption.  If an .FPT
                  or .SMT memo file is to be corrected, an optional numeric
                  value can be included to indicate the block size that the
                  memo file should be using.  (Ex: /f16).  If no value is
                  specified, the block size in the memo file header will not
                  be modified.

             /p = Create a .PRG file with Clipper source code to create the
                  specified .DBF file.  (Ex: /pTEST).  If no name is
                  specified, STRU.PRG will be created.

      /r<x>:<c> = Rename a field. <x>=Old Name|Number, <c>=New Name.
                  ( Ex: /rOLDNAME:NEWNAME  or  /r3:NEWNAME ).

          /s<n> = Resize (REDUCE) .DBF to specified number of records.
                  (Ex: /s100)

  Examples:

    // Display structure of TEST.DBF
    DBFINFO test

    // Display structure of TEST.DBF and correct any detected corruptions
    DBFINFO test /f

    // Display structure of TEST.DBF and create STRU.PRG
    DBFINFO test /p

    // Display structure of TEST.DBF and create FOO.PRG
    DBFINFO test /pFOO