Use the code Buddy wrote below, but "DIR C:\winnt\*.* /s" should get the sub directories too.
Oh, wait, you would need to put this dir command in a batch file to build the file. Filedir.bat Dir c:\winnt\*.* /s > junk.dat >From your rbase program you need something like Zip command /c filedir.bat Troy _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Walker, Buddy Sent: Wednesday, June 30, 2004 7:54 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Capturing the DIR command Bernie You could try something like this. This will not pick up sub folders. You maybe able to make the columns shorter depending on your filenames. Hope it helps Buddy *********** SET MESS OFF SET ERR MESS OFF OUT JUNK.DAT DIR C:\WINNT\*.* OUT TERM DROP TABLE FileDirectory CREATE TEMPORARY TABLE FileDirectory + (Col1 TEXT (55), + Col2 TEXT (55), + Col3 TEXT (55), + Col4 TEXT (10), + Col5 TEXT (55), + Col6 TEXT (55)) LOAD FileDirectory FROM JUNK.DAT DEL ROWS FROM FileDIrectory whe count = 1 CHOOSE VFileName FROM #VALUES FOR ( (LJS(Col4,8)) & Col6),Col6 + FROM FileDirectory FORMATTED RETURN ****************************************** -----Original Message----- From: Bernard Lis [mailto:[EMAIL PROTECTED] Sent: Wed 6/30/2004 9:28 PM To: RBG7-L Mailing List Cc: Subject: [RBG7-L] - Re: Capturing the DIR command I tried that but -- Is there a way that LoadFileName can display the A: drive without the operator having to select the A: drive. They don't know A from B from C. I need to use the kiss system. Bernie ----- Original Message ----- From: "MikeB" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, June 30, 2004 9:16 PM Subject: [RBG7-L] - Re: Capturing the DIR command > > ----- Original Message ----- > From: "Bernard Lis" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > Sent: Wednesday, June 30, 2004 7:38 PM > Subject: [RBG7-L] - Capturing the DIR command > > > > I want to display the file name and date on a diskette in order to display > > it to make sure the operator inserts the correct disk. > > > > I can do zip cmd /c dir a: > xx > > and xx will contain what you get by doing dir a: at a command prompt. But I > > can't seem to correctly load a table with the data. > > > > Anyone have any other ideas how i can display the file name and date? > > Actually, the LoadFileName plugin when activated, you can set the display in the > listbox to show "Details" and all the files and dates will show there. > > > Bernie Lis > > > >
<<attachment: winmail.dat>>
