DISPLAY FILES Command
Displays information about files.
DISPLAY FILES [ON Drive] [LIKE FileSkeleton] [TO PRINTER [PROMPT] | TO FILE FileName]
- 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.
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