Export (0) Print
Expand All
Expand Minimize

DISPLAY FILES Command

Displays information about files.


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

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.

ADDITIVE

Appends to the end of the named file. If you omit ADDITIVE, then the file is overwritten with the value of the expression.

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.

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

Community Additions

ADD
Show:
© 2014 Microsoft