Thanks everyone for your responses.
Below is what I ended up with.
What this was all about is that the warehouse sends an order to a store.
Along with the merchandise, is a diskette that contains the items being
shipped. This is then used to update their QOH and for them to print a
receiver.
What happened is that the store clerk inserted a disk from the week before
and you know what that did!
SET MESS OFF
SET ERR MESS OFF
OUT JUNK.DAT
DIR A:
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
sel col1,col2,col4 into c1,c2,c3 from filedirectory where limit=1
set var vfile = (.c1 & .c2 & .c3)
DIALOG 'Is This The Correct Date and file Name' vResp vKey YES +
CAPTION .vfile ICON QUESTION
RETURN
----- Original Message -----
From: "Bernard Lis" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, June 30, 2004 10:17 PM
Subject: [RBG7-L] - Re: Capturing the DIR command
> Hey Buddy,
> That's exactly what I need, thanks whole bunches.
> Bernie Lis
> ----- Original Message -----
> From: "Walker, Buddy" <[EMAIL PROTECTED]>
> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]>
> Sent: Wednesday, June 30, 2004 9:54 PM
> 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
> > > >
> > >
> > >
> >
> >
>
