I just tested on XP, Vista, and Windows 7 and all worked the same.
Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Monday, January 16, 2012 3:16 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: The DIR command 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?
