home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
World of Shareware - Software Farm 2
/
wosw_2.zip
/
wosw_2
/
DATABASE
/
DBFSCA.ZIP
/
DBFSCAN.DOC
next >
Wrap
Text File
|
1992-05-17
|
15KB
|
457 lines
DBFSCAN
version 1.0
Utility program to find which DBF's contain a Dbase Field
by
William P. York
Computer Team, Inc.
1049 State Street
Bettendorf, Iowa 52722
(319) 355-0426
Copyright (c) 1991 by Computer Team, Inc.
_____________________________________________________________________
LICENSE
_____________________________________________________________________
DBFSCAN is NOT public domain or free software, but is being
distributed as "shareware".
Non-registered users of this software are granted a limited license
to make an evaluation copy for trial use on a private, non commercial
basis, for the express purpose of determining whether DBFSCAN is
suitable for their needs. At the end of this trial period, you
should either register your copy or discontinue using DBFSCAN.
In other words, if you regularly use this program then you should pay
for your copy.
A DBFSCAN registration entitles you to use the program on any and all
computers available to you, with the following restriction: If other
people have access to this program or may use it, then you should
purchase a site license.
All users are granted a limited license to copy DBFSCAN only for the
trial use of others and subject to the above limitations.
This license does NOT include distribution or copying of this
software for the following:
1. In connection with any other product or service.
2. For general use within a company or institution.
3. For any fee other than a nominal 'disk charge' not to
exceed $7.00
4. Distribution in modified form; the full DBFSCAN documentation
and REGISTER documentation must be included, unmodified.
Operators of electronic bulletin board systems (Sysops) are
encouraged to post DBFSCAN for downloading by their users, as long as
the above conditions are met.
TABLE OF CONTENTS
INTRODUCTION . . . . . . . . . . . . . . . . . . . . . . . . . . 2
BONUS FOR CLIPPER PROGRAMMERS . . . . . . . . . . . . . . . . . . 2
INSTALLATION . . . . . . . . . . . . . . . . . . . . . . . . . . 3
HOW TO USE DBFSCAN . . . . . . . . . . . . . . . . . . . . . . . 3
Edit Field Names . . . . . . . . . . . . . . . . . . . . . . 3
Edit Paths . . . . . . . . . . . . . . . . . . . . . . . . . 3
Edit Report Name . . . . . . . . . . . . . . . . . . . . . . 4
Create Report . . . . . . . . . . . . . . . . . . . . . . . 4
View Report . . . . . . . . . . . . . . . . . . . . . . . . 4
Print Report . . . . . . . . . . . . . . . . . . . . . . . . 4
Exit . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
SAMPLE REPORT . . . . . . . . . . . . . . . . . . . . . . . . . . 5
MISCELLANEOUS . . . . . . . . . . . . . . . . . . . . . . . . . . 6
FINAL DISCLAIMER . . . . . . . . . . . . . . . . . . . . . . . . 6
-1-
INTRODUCTION
DBFSCAN is a utility program for the xBase programmer. It provides a
quick and easy method to locate all of the DBF files which contain
one or more specific FIELD names. It works with all DBASE III+
compatible DBF file formats. This includes DBASE III+, CLIPPER and
FOX database files.
In simple terms, DBFSCAN will examine all DBF files in the specified
directories and create a report listing those DBF files which contain
any of the FIELD names that you have entered.
This program was written to save time when doing xBase program
maintenance. When we needed to modify a FIELD's size or see if a
FIELD name was already used, we would manually look at the DBF
structures. DBFSCAN was written to automate this process.
BONUS FOR CLIPPER PROGRAMMERS
If your index files were created with CLIPPER and your index file
names match your DBF file names, then DBFSCAN will list those index
files which contain any of the FIELD names that you entered.
For example, if you are looking for all DBF's which contain the FIELD
name CUSTNUMBER, and if DBFSCAN locates CUSTNUMBER in the file
CUST.DBF, then DBFSCAN will look to see if the file CUST.NTX exists
and if it does, DBFSCAN will report if the formula used to create the
index file contained CUSTNUMBER.
-2-
INSTALLATION
To install DBFSCAN all you need to do is 'unfold' DBFSCAN from the
compressed format in which it is normally distributed. You may
choose to create a separate subdirectory for DBFSCAN or put DBFSCAN
in your Dbase programming tools subdirectory.
HOW TO USE DBFSCAN
To start DBFSCAN, enter DBFSCAN from the DOS prompt. If the
subdirectory which contains DBFSCAN.EXE is included in your PATH
statement, you can enter DBFSCAN from any subdirectory.
When you enter DBFSCAN, you will see a screen with the below Menu:
.---------- Menu ----------.
| 1) Edit Fields |
| 2) Edit Paths |
| 3) Edit Report Name |
| 4) Create Report |
| 5) View Report |
| 6) Print Report |
| 7) Exit |
--------------------------
To select an entry, you can either:
a) Use the Up/Down arrow keys to highlight the desired choice and
then press enter.
b) Enter the Number (1 through 7) of the desired choice.
Edit Field Names: Use this option to enter the Dbase FIELD names
that want to search on. You can enter up to 15
different FIELD names. Press ENTER after you
have typed each FIELD name. Press PgDn after
entering the last FIELD name.
Edit Paths: Use this option to enter the DOS PATH's for the
subdirectories that contain the DBF files that
you want to search. You can enter up to 5
different PATH statements. Press ENTER after
you have typed each PATH statement. Press PgDn
after entering the last PATH statement. You
must enter fully qualified PATH statements.
For example; C:\PAYROLL\DATA
-3-
Edit Report Name: Use this option to enter the DOS file name
where DBFSCAN will output the report. This
file will be located in the subdirectory
that you currently are working in. DBFSCAN
will store the report in ASCII format in
this DOS file. If the file name previously
existed, DBFSCAN will overlay it with the
new report. For example, you could use a
report file name like DBFSCAN.REP
Create Report: Use this option to create a new report. Each
time you execute DBFSCAN, you should select
this option. A message box will display while
the report is being created. The amount of
time needed to create a report will depend on
the number of Dbase FIELD's and the number of
DBF files that you are searching.
View Report: Use this option to view the report created by
option "4) Create Report". While you are
viewing the report, you can use the Up/Down
arrow keys and the PgUp/PgDn keys to scroll
through the report. When you are finished
viewing the report, press ESC to return to
DBFSCAN menu.
Print Report: Use this option to print the report created by
option "4) Create Report". This option will
print the report to LPT1. If you need to print
to a different port, then you will need to exit
DBFSCAN and use the DOS "TYPE" command to print
the report. For example, if you need to print
to LPT2 and your report name is DBFSCAN.REP,
then would enter: TYPE DBFSCAN.REP > LPT2:
Exit: Use this option to exit DBFSCAN and return to
the DOS prompt.
-4-
SAMPLE REPORT
________________________________________________________________
| |
| Date: 05/16/92 DBFSCAN Time: 16:10:19 |
| |
| DIRECTORY: C:\ACCOUNTS\DATA |
| |
| ----------------------------------------------------------- |
| FIELD DBF TYPE LEN DEC INDEX |
| ----------------------------------------------------------- |
| FCUSTNO APMEM01 C 10 0 |
| FCUSTNO ARAUI01 C 10 0 FCUSTNO |
| FCUSTNO ARAUT01 C 10 0 |
| FCUSTNO ARCAS01 C 10 0 FCUSTNO+FSYSCHK |
| FITEMNO ARAUT01 C 20 0 |
| FITEMNO ARHTR01 C 20 0 |
| FITEMNO ARITM01 C 20 0 FITEMNO |
| FITEMNO ARTRF01 C 20 0 FITEMNO |
| |
| DIRECTORY: C:\TIMEBILL\DATA |
| |
| ----------------------------------------------------------- |
| FIELD DBF TYPE LEN DEC INDEX |
| ----------------------------------------------------------- |
| FCUSTNO TBAUI01 C 6 0 FCUSTNO |
| FCUSTNO TBCAS01 C 6 0 FCUSTNO |
| FCUSTNO TBHCA01 C 6 0 |
| FCUSTNO TBINV01 C 6 0 |
| |
|________________________________________________________________|
The above sample report was created by searching for Dbase FIELD's
FCUSTNO and FITEMNO in PATH's C:\ACCOUNTS\DATA and C:\TIMEBILL\DATA.
The DATE and TIME that the report was created are shown on the top
line of the report.
Search results for each PATH are separated by a heading which lists
the specific PATH. Within each PATH, FIELD's are listed in the order
they are entered on the DBFSCAN menu screen.
Since the above sample report was created for our CLIPPER databases
it includes INDEX information. When you use DBFSCAN on database
systems other than CLIPPER, the INDEX area will be blank.
The sample report shows in DBF files in C:\ACCOUNTS\DATA that FCUSTNO
has a Length of 10 and in DBF files in C:\TIMEBILL\DATA that FCUSTNO
has a Length of 6.
-5-
MISCELLANEOUS
DBFSCAN was written in Clipper and should run on all IBM's and true
compatible's and with nearly any video adapter.
DBFSCAN is being distributed as SHAREWARE; you are free to make as
many copies of them as you like, and to share it with others.
However, you may NOT modify it and the program and documentation must
travel together. If you find DBFSCAN useful, you are encouraged to
register your copy. The license fee is only $20, and if you've done
any programming, you know the amount of time and energy that goes
into a program such as DBFSCAN. $20 is far less than you would pay
for a "commercial" program of the same quality. If personal
satisfaction isn't incentive enough for you, registered users will
also receive the latest version (without any title screen delay), and
free updates for a year.
We hope that you find DBFSCAN useful, and we encourage you to
register. We are always open to suggestions, whether you're
registered or not. We would also appreciate reports of any problems
with the software. You may send any contributions, suggestions or
problems to:
Computer Team, Inc.
1049 State Street
Bettendorf, Iowa 52722
(319) 355-0426
FINAL DISCLAIMER
Use of this program acknowledges this disclaimer of warranty:
"This program is supplied as-is. Computer Team, Inc. disclaims all
warranties, expressed or implied, including, without limitation, the
warranties of merchantability and of fitness of this program for any
purpose. Computer Team, Inc. assumes no liability for damages direct
or consequential, which may result from the use of this program."
-6-