Difference between revisions of "SYSFILES"
From Lianjapedia
Yvonne.milne (Talk | contribs) (Created page with "==Purpose== Description of files in the current directory ==See Also== ADIR(), DBF(), FILEINFO(), FSIZE(), GETENV(), NDX(), SET FULLPATH, TABLEI...") |
Barrymavin (Talk | contribs) (→Example) |
||
| Line 23: | Line 23: | ||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| − | select * from sysfiles where filename =="*.jpg" | + | select * from sysfiles where filename == "*.jpg" into cursor myfiles |
</code> | </code> | ||
Latest revision as of 10:56, 3 March 2022
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
