Difference between revisions of "DIR"
m (Text replace - "Recital" to "Lianja") |
Yvonne.milne (Talk | contribs) (→See Also) |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 6: | Line 6: | ||
==See Also== | ==See Also== | ||
| − | [[ADIR()]], [[DECRYPT]], [[DISPLAY FILES]], [[ENCRYPT]], [[LIST FILES]] | + | [[ADIR()]], [[CREATE TABLE]], [[DECRYPT]], [[DEFAULT()]], [[DISPLAY FILES]], [[DROP TABLE]], [[ENCRYPT]], [[LIST FILES]], [[LIST STATUS]], [[LIST STRUCTURE]], [[OPEN DATABASE]], [[SET DEFAULT]] |
==Description== | ==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 | + | 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 files only. | + | 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: | |
| − | * | + | |
| − | * Number of | + | * Table name |
| − | * Last | + | * Number of records |
| − | * Size | + | * Last update date |
| − | * Dictionary status | + | * Size |
| − | * Triggers status | + | * Dictionary status (Yes/None) |
| − | * Security status | + | * Triggers status (Yes/None) |
| − | * | + | * Security status (Yes/None) |
| − | * | + | |
| − | * Drive space remaining | + | 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== | ==Example== | ||
Latest revision as of 06:03, 21 December 2020
Contents
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
