I assume RBASE's dir command will output consistent results across multiple
OS's. Correct me if I am wrong, Bill.
Here is a snippet I use to get a list of JPG filenames into a table
Once could play with the dates too, but I was just interested in the filespecs.
Neat thing is I can put a DBimage on a scrolling region based on this table
and display the images.
SET ERROR MESSAGE 2038 OFF
DROP TABLE TempFiles
SET ERROR MESSAGE 2038 ON
CREATE TEMP TABLE TempFiles (TempFileName TEXT (180))
SET NULL ' '
SET VAR vFilespec = (.vSourceDir +'*.jpg')
SET VAR vTmpFile = (FILENAME(0))
OUTPUT .vTmpFile
DIR .vFilespec
OUTPUT SCREEN
LOAD TempFiles FROM .vTmpFile AS FORMATTED USING TempFileName 42 200
ERASE .vTmpFile
DELETE FROM TempFiles WHERE TempFileName NOT LIKE '%.jpg'
DELETE FROM TempFiles WHERE TempFileName IS NULL
SELECT COUNT(*) INTO vFileCount FROM TempFiles
IF vFileCount > 0 THEN
UPDATE TempFiles SET TempFileName = (.vSourceDir + TempFileName)
ENDIF
Dennis McGrath
Software Developer
QMI Security Solutions
1661 Glenlake Ave
Itasca IL 60143
630-980-8461
[email protected]
________________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall
Sent: Monday, January 16, 2012 2:45 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: The DIR command
Michael,
You can try something like this:
ZIP CMD.EXE /c DIR \\sharename\foldername\*.TIF /o-d > mydiroutput.txt
cmd.exe is the "shell", the command prompt.
/c tells it to run, then exit the command prompt
Then comes your DIR command
Then comes an output redirection operator ">"
Then comes the name of the file where you want the output.
Then R:BASE can "type" the file, or load it as a fixed-width file into a
temporary table.
A warning though: If all the computers that run this application are not
running the same versions of Windows, there may be slight differences in the
positions of the details in the DIR listing.
Bill
On Mon, Jan 16, 2012 at 2:41 PM, Michael J. Sinclair <[email protected]>
wrote:
Hi All,
Is there a way to use the DIR command from within Rbase 9.1 similar to the way
it used from a command prompt?
For example, from a command prompt, I can type...
DIR /O:d or DIR /O:-d
and the output will sort the filenames by date, oldest to newest or newest to
oldest.
Can that be done from with Rbase 9.1?
