DISPLAY FILES Command

Displays information about files.

DISPLAY FILES [ON Drive] [LIKE FileSkeleton] 
   [TO PRINTER [PROMPT] | TO FILE FileName]

Parameters

  • ON Drive
    Specifies the drive or volume on which the files reside.

  • LIKE FileSkeleton
    Specifies a condition whereby Visual FoxPro displays information only about files that match the skeleton pattern FileSkeleton. The skeleton pattern can contain wildcards such as ? and *.

  • TO PRINTER [PROMPT]
    Directs output from DISPLAY FILES to a printer.

    In Visual FoxPro, you can include the optional PROMPT clause to display a dialog box before printing starts. In this dialog box, you can adjust printer settings, including the number of copies and page numbers to print. The printer settings that you can adjust depend on the currently installed printer driver. Place the PROMPT keyword immediately after TO PRINTER.

  • TO FILE FileName
    Directs output from DISPLAY FILES to the file specified with FileName. If the file already exists and SET SAFETY is ON, you are asked if you want to overwrite the file.

Remarks

Use DISPLAY FILES to display information about files residing on a disk. You can display information about all files on a specified drive, volume, directory, or folder, or only files that match a skeleton pattern containing wildcards such as ? and *.

Issuing DISPLAY FILES without any arguments displays information about tables in the current directory. The information displayed includes the following:

  • Table name.
  • Number of records in the table.
  • Date and time of the last update to the table.
  • The size of each table in bytes.
  • If each table is part of a database.

Example

The following example displays the names of the databases in the \Samples\Data directory.

CLOSE DATABASES
OPEN DATABASE (HOME(2) + 'Data\testdata')

CLEAR
DISPLAY FILES LIKE *.DBC

See Also

DIR or DIRECTORY | LIST | DISPLAY DATABASE Command