On Jan 12, 2009, at 11:21 PM, MB Software Solutions General Account
wrote:
Our plan (ADIR and then USE / RECCOUNT) is simple and easy. What's
harder?
Doing it any other way!
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance:
Ken Kixmoeller/fh wrote:
On Jan 12, 2009, at 11:21 PM, MB Software Solutions General Account
wrote:
Our plan (ADIR and then USE / RECCOUNT) is simple and easy. What's
harder?
Doing it any other way!
LOL...agreed! ;-)
___
Post Messages to:
Has anyone ever seen a tool to take the output from a DIR and put it into
a DBF or CURSOR? I've got a need to assess the # of records in a data
folder (free standing tables--no dbc) at various client sites and thought
something like that would be super easy for getting this information to
me.
If
What does that give you ADIR() doesn't?
Tracy
-Original Message-
From: MB Software Solutions General Account
Sent: Monday, January 12, 2009 2:19 PM
Has anyone ever seen a tool to take the output from a DIR and put it into a
DBF or CURSOR? I've got a need to assess the # of records in a
[mailto:profoxtech-boun...@leafe.com]on Behalf Of MB Software Solutions
General Account
Sent: Monday, January 12, 2009 2:19 PM
To: profoxt...@leafe.com
Subject: DIR into table
Has anyone ever seen a tool to take the output from a DIR and put it into
a DBF or CURSOR? I've got a need to assess
: Monday, January 12, 2009 1:48 PM
To: profoxt...@leafe.com
Subject: RE: DIR into table
What does that give you ADIR() doesn't?
Tracy
-Original Message-
From: MB Software Solutions General Account
Sent: Monday, January 12, 2009 2:19 PM
Has anyone ever seen a tool to take
PROCEDURE filetree
PARAMETER lcpath
CREATE CURSOR filetree (name C(100),;
size N(9), ;
update D,;
uptime C(8),;
How does a DOS DIR command give you # of records in a table?
The return value of ADIR() gives you the number of tables in the directory.
Tracy
-Original Message-
From: Gil Hale
Sent: Monday, January 12, 2009 2:03 PM
It was ADIR() I had in mind for a Fox code based solution. I use
[mailto:profoxtech-boun...@leafe.com]on Behalf Of Gil Hale
Sent: Monday, January 12, 2009 2:03 PM
To: profoxt...@leafe.com
Subject: RE: DIR into table
It was ADIR() I had in mind for a Fox code based solution. I use
ADIR() for
all kinds of other things, but never to handle that kind of slution
It doesn't. I misread the post. I was after the bytes with that little
chore.
Gil
-Original Message-
From: profoxtech-boun...@leafe.com
[mailto:profoxtech-boun...@leafe.com]on Behalf Of Tracy Pearson
Sent: Monday, January 12, 2009 2:06 PM
To: profoxt...@leafe.com
Subject: RE: DIR
Come on, that's too easy! heh-heh... Looks great.
Gil
-Original Message-
From: profoxtech-boun...@leafe.com
[mailto:profoxtech-boun...@leafe.com]on Behalf Of Jean Laeremans
Sent: Monday, January 12, 2009 2:07 PM
To: profoxt...@leafe.com
Subject: Re: DIR into table
PROCEDURE
On Mon, January 12, 2009 1:48 pm, Tracy Pearson wrote:
What does that give you ADIR() doesn't?
Actually, I had forgotten about that one BUT ADIR does NOT give the record
count of the tableand that's at the core of the request/need.
___
Post
On Mon, January 12, 2009 1:59 pm, Gil Hale wrote:
I had to do that once, long ago. I took a brute force approach as it was
a one-off situation. I shelled to Command Prompt and changed to the
directory in question. I then ran dir *.dbf file_list.txt
I then took the resultant file_list.txt
On Mon, January 12, 2009 2:09 pm, Gil Hale wrote:
DIR pauses for screen output, and has no no console. I tried list
files to file file_list.txt and got what I needed in the resultant text
file.
From there it is a matter of breaking out the pieces and populating a
table.
Exactly...it's just
On Mon, January 12, 2009 2:11 pm, Gil Hale wrote:
Come on, that's too easy! heh-heh... Looks great.
...and provides basically the same kind of info as ADIR (recursed) but
still doesn't give me the requirement of this request---the table record
count. ;-)
Also, you may want to add this line
Solutions
General Account
Sent: Monday, January 12, 2009 3:22 PM
To: profoxt...@leafe.com
Subject: RE: DIR into table
On Mon, January 12, 2009 2:11 pm, Gil Hale wrote:
Come on, that's too easy! heh-heh... Looks great.
...and provides basically the same kind of info as ADIR (recursed
On Jan 12, 2009, at 2:03 PM, Gil Hale wrote:
still doesn't give me the requirement of this request---the table
record
count. ;-)
What, you are back to that again? Let it go, man, chill... heh-heh
Mike - --
Why not just take the results of the ADIR() and open each table with
an
On Mon, Jan 12, 2009 at 2:22 PM, MB Software Solutions General Account
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
On Mon, January 12, 2009 2:11 pm, Gil Hale wrote:
Come on, that's too easy! heh-heh... Looks great.
...and provides basically the same kind of info as ADIR (recursed)
So many ways to skin a Fox, eh? It is nice to have options...
Gil
-Original Message-
From: profoxtech-boun...@leafe.com
[mailto:profoxtech-boun...@leafe.com]on Behalf Of Stephen Russell
Sent: Monday, January 12, 2009 3:31 PM
To: profoxt...@leafe.com
Subject: Re: DIR into table
Check out LIST FILES in the help. Unlike DIR, it does not pause after
each screen and it does include record count for DBFs.
MB Software Solutions General Account wrote:
On Mon, January 12, 2009 2:09 pm, Gil Hale wrote:
DIR pauses for screen output, and has no no console. I tried list
On Mon, Jan 12, 2009 at 3:01 PM, Gil Hale g...@gilhale.com wrote:
So many ways to skin a Fox, eh? It is nice to have options...
I use to have a prg that would browse all the tables instead of return
rowcount.
--
Stephen Russell
Sr. Production Systems Programmer
MB Software Solutions General Account wrote:
On Mon, January 12, 2009 1:59 pm, Gil Hale wrote:
I had to do that once, long ago. I took a brute force approach as it was
a one-off situation. I shelled to Command Prompt and changed to the
directory in question. I then ran dir *.dbf
On Mon, Jan 12, 2009 at 4:48 PM, Ricardo Aráoz ricar...@gmail.com wrote:
MB Software Solutions General Account wrote:
On Mon, January 12, 2009 1:59 pm, Gil Hale wrote:
int totalCount =0;
m_dir = new DirectoryInfo(sFolder);
ArrayList alFiles = new ArrayList();
foreach (FileInfo f in
This is how I have done the same thing - only I open the txt file using
FOPEN()
Jeff
Jeff Johnson
j...@san-dc.com
SanDC, Inc.
623-582-0323
Fax 623-869-0675
Phoenix Python User Group - sunpigg...@googlegroups.com
MB Software Solutions General Account wrote:
On Mon, January 12, 2009 1:59 pm,
Ken Kixmoeller/fh wrote:
On Jan 12, 2009, at 2:03 PM, Gil Hale wrote:
still doesn't give me the requirement of this request---the table
record
count. ;-)
What, you are back to that again? Let it go, man, chill... heh-heh
Mike - --
Why not just take the results of the ADIR() and open
Stephen Russell wrote:
If you are using the dbc why not go against that as your source?
Um...that was in the opit's all free tables.
other way is to brute force it:
adir() for any .dbfs
for loop to see if you can open the table and get a reccount form it.
yep...that's the current
Gil Hale wrote:
So many ways to skin a Fox, eh? It is nice to have options...
That is a great strength of the Fox!
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this
Ken Kixmoeller/fh wrote:
On Jan 12, 2009, at 7:46 PM, MB Software Solutions General Account
wrote:
Yepthat's what I was planning to do as a Plan B. Thanks for
echoing
that thought, Ken! ;-)
Why make things harder than they need to be???
Our plan (ADIR and then USE / RECCOUNT) is
28 matches
Mail list logo