SYSFILES
From Lianjapedia
Revision as of 10:56, 3 March 2022 by Barrymavin (Talk | contribs)
Contents
Purpose
Description of files in the current directory
See Also
ADIR(), DBF(), FILEINFO(), FSIZE(), GETENV(), NDX(), SET FULLPATH, TABLEINFO()
Description
System Tables are system defined read-only tables. You can query these tables using the SELECT statement.
| Column | Data Type | Width | Description |
|---|---|---|---|
| FILENAME | C | 80 | FILENAME |
| DATE | C | 10 | DATE |
| TIME | C | 8 | TIME |
| SIZE | N | 18 | SIZE |
Example
select * from sysfiles where filename == "*.jpg" into cursor myfiles
