home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
DP Tool Club 12
/
CD_ASCQ_12_0294.iso
/
vrac
/
dbf2dc.zip
/
DBF2DCT.DOC
next >
Wrap
Text File
|
1994-01-28
|
4KB
|
85 lines
A DBF/Clarion Data Dictionary Utility
For Clarion 3.0
by
Stephen Genusa
************************************************************************
This program and all associated data carries no warranty express or
implied. By using this data in any format, for any purpose, you agree
not to hold Stephen Genusa liable for special, incidental, or consequential
damages, including loss of profits, regardless of whether Stephen Genusa
has been advised that such damages may be incurred.
************************************************************************
These programs are "BETA." If they help you get your project completed
quicker than manual input --GREAT! I am glad to have helped. On the
other hand if you have problems, I'd be glad to help you in any way I
can. Just contact me and I'll see what I can do. I would appreciate
at least a thank you note (mail, email address is internet:
sgenusa@delphi.com) if you use these programs.
This program is designed to read the DBF structure and import in
directly into a Clarion DCT file. BTrieve must be loaded.
The usage screen is as follows:
Usage: DBF2DCT [/Iinput.dbf] [/Ooutput.dct] [/Fx] [/V] [/Kx,y,z]
/Fx = Format of data file that DCT will have for this file
C = Clipper
3 = dBase3
4 = dBase4
F = FoxPro
For example /F3 = dBase3
/K=Key Names
For example /Fempname,empno = Reads IDX or NDX structures for files
empname.xxx and empno.xxx. Does *NOT* handle expressions
/V=oVerwrite Existing Dictionary
Examples:
dbf2dct junk /F4 - DCT file called junk with junk.dbf struct in dBase4
If DCT junk exists attempts to add junk.dbf - if it
does not exist it is created.
dbf2dct junk /F4 /v - overwrite DCT if it exists
dbf2dct junk /ostuff /FC - specifies DCT filename to be stuff.dct.
If the dictionary file specified as output does not exist then it will be
created. If it does exist the /v will overwrite the *entire* DCT file with
only the new DBF structure in it. If the DCT does exist but the DBF file
does not exist in it, it will be added.
A utility has been added-MDBF. It takes the same parameters as DBF2DCT but
for the input DBF file you can use a mask such as *.dbf or m*.dbf and all
the proper DBF files will be added to the same dictionary. You must specify
an output dictionary file name (/Oxxxxxxxx.dct). To create a dictionary
called CH.DCT containing all DBF files in the current directory just call
MDBF like this:
MDBF *.* /Och
MDBF calls DBF2DCT with the correct parameters.
If you find these utilities useful a small donation (say $25) would be
appreciated--those who register will receive info on updates. Your
comments are requested and appreciated.
Stephen Genusa
9107E Derbyshire Road
Richmond, VA 23229
Home: 804-741-8255
Changes:
01/21/94 - Version .5
First release.
01/24/94 - Version .6
Fixed the limited number of fields available in version .5.
Fixed display picture for date fields.
01/27/94 - Version .7
Added keys for dBase3 and Foxpro - does *NOT* support
expressions.
Add MDBF - adds multiple DBFs to a dictionary by file mask.