DIR

From Lianjapedia
Jump to: navigation, search

Purpose

Display a directory of files

Syntax

DIR [<skeleton>]

See Also

ADIR(), CREATE TABLE, DECRYPT, DEFAULT(), DISPLAY FILES, DROP TABLE, ENCRYPT, LIST FILES, LIST STATUS, LIST STRUCTURE, OPEN DATABASE, SET DEFAULT

Description

The DIR command displays filenames in the current directory and path (see SET PATH) matching the specified <skeleton>. The total number of files matching the <skeleton>, their total size and the remaining drive space are also displayed.

If DIR is issued with no <skeleton> specified, then it will list details of the table and virtual table files only.

With no database open, the file listing displays the following information for tables:

  • Table name
  • Number of records
  • Last update date
  • Size
  • Dictionary status (Yes/None)
  • Triggers status (Yes/None)
  • Security status (Yes/None)

The following information for virtual tables:

  • Table / virtual table name and connection string

And the following size information:

  • Total size of tables
  • Drive space remaining

With a database open, the file listing displays the following information:

  • Table / virtual table name
  • Table / virtual table path
  • Table / virtual table type (Table/VirtualTable)
  • Virtual table connection string, alias, primary key, command and properties

Example

dir
dir *.prg