OK, I understand. I have a table of the following structure:
No. Column Name Attributes
--- ------------------ ----------------------------------------------------
--
1 CmdName Type : TEXT 8 NOT NULL
Consrnt: PRIMARY KEY
Comment: Name of The Command
2 CmdFullName Type : TEXT 20
3 ZigSystem Type : TEXT 1 NOT NULL
Comment: Required For Db and App To
Function
Y or N
4 CmdType Type : TEXT 8 NOT NULL
Comment: File, Folder, Run
5 CmdLocation Type : TEXT 256 NOT NULL
Comment: Location Relative to DB
6 CmdData Type : LONG VARCHAR
Comment: Command Data
The CmdType tells if it is a file or folder. I use a script to process the
info to determine if the file is present or not. If it is not, the file is
stored as a VarChar and is written back to its expected location. This is
done on startup each time. There is error handling if it is not successful
and to summon appropriate help and the app is not allowed to continue in the
absence of required files. As more functions are being added to RBase, a
lot of this can be accomplished without using a Script.
I am just putting the Required info into a table and checking to see if it
is there as the Required remains pretty static unless more required files or
folders are added, then checking if they are there.....
Sample Table Data:
CmdName CmdFullName ZigSyste CmdType CmdLocation
-------- -------------------- -------- -------- ---------------------------
--
STARTUP STARTUP N Run Select
delfile delfile N Run Select
FileSize FileSize.vbs Y File \Script\FileSize.vbs
RbMsgBox RbMsgBox.vbs Y File \Script\RbMsgBox.vbs
BdcWeb BdcWeb.vbs Y File \Script\BdcWeb.vbs
Script Script Y Folder \Script
RbSysChk RbSysChk.vbs N File .
ScrnRes ScrnRes.vbs N File \Script\ScrnRes.vbs
QuoBack QuoBack Y Folder \QuoBack
pkunzip pkunzip.exe N File .
pkzip pkzip.exe N File .
Zip2Exe Zip2Exe.exe N File .
PkWare PkWare Y Folder \PkWare
GtFldr GtFldr.vbs Y File \Script\GtFldr.vbs
----- Original Message -----
From: "Thomas J Cimicato" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 20, 2002 3:14 PM
Subject: Re: Reading a directory
> I need it in a table. My app knows what files "should" be there and I need
> to determine what files are actually there. Conversely, is a file there
> that should not be.
>
> This would make a great UDF or R:Base function. Being able to do something
like
>
> Select all from #LFILES.... and get a list of files in a given
directory
> like you can with the choose command.
>
> Thom
>
> At 10:08 AM 09/20/2002 -0500, you wrote:
> >Do you need this in a Table? Or would you like a List at Runtime in a
> >TempTable or a Choose Or is it that you Just need to select a FileName
from
> >a popup?
> >
> >
> >----- Original Message -----
> >From: "Thomas J Cimicato" <[EMAIL PROTECTED]>
> >To: <[EMAIL PROTECTED]>
> >Sent: Friday, September 20, 2002 3:27 AM
> >Subject: Reading a directory
> >
> >
> > > How would one go about creating a table of file names in a given
> >directory?
> > > I'm sure someone has done this before somehow.
> > >
> > > Thom
> > > Thomas J Cimicato
> > > President
> > > Integrated Check Technologies
> > > Collect-A-Check, Inc.
> > > ------------------------------------------------------------
> > > Bus:800.338.0676
> > > Mailto:[EMAIL PROTECTED]
> > > www.ICheckTech.com
> > >
> > > ================================================
> > > TO SEE MESSAGE POSTING GUIDELINES:
> > > Send a plain text email to [EMAIL PROTECTED]
> > > In the message body, put just two words: INTRO rbase-l
> > > ================================================
> > > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> > > In the message body, put just two words: UNSUBSCRIBE rbase-l
> > > ================================================
> > > TO SEARCH ARCHIVES:
> > > http://www.mail-archive.com/rbase-l%40sonetmail.com/
> > >
> >
> >================================================
> >TO SEE MESSAGE POSTING GUIDELINES:
> >Send a plain text email to [EMAIL PROTECTED]
> >In the message body, put just two words: INTRO rbase-l
> >================================================
> >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> >In the message body, put just two words: UNSUBSCRIBE rbase-l
> >================================================
> >TO SEARCH ARCHIVES:
> >http://www.mail-archive.com/rbase-l%40sonetmail.com/
>
> Thomas J Cimicato
> President
> Integrated Check Technologies
> Collect-A-Check, Inc.
> ------------------------------------------------------------
> Bus:800.338.0676
> Mailto:[EMAIL PROTECTED]
> www.ICheckTech.com
>
> ================================================
> TO SEE MESSAGE POSTING GUIDELINES:
> Send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: INTRO rbase-l
> ================================================
> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
> In the message body, put just two words: UNSUBSCRIBE rbase-l
> ================================================
> TO SEARCH ARCHIVES:
> http://www.mail-archive.com/rbase-l%40sonetmail.com/
>
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
