home *** CD-ROM | disk | FTP | other *** search
- DBF.Com -- dBASE III / FoxBASE+ Database structure lister
-
- Copyright (c) 1988, by Matrix Software Systems
- All rights reserved
-
- This program will list the structure of any dBASE III /FoxBASE +
- database file in a format similar to "List Structure." It is similar to
- another PD program (ListStru.COM) except that this version handles the
- full set of MS-DOS wildcards (both of them), comes complete with source
- code (for use with Turbo C), and is about one-half the size.
-
- This program is provided on an "as-is" basis. No warranty, expressed or
- implied, covers this program. Matrix Software Systems disclaims all
- conditions and warranties, whether express or implied with regard to
- this program, including all implied conditions or warranties of
- merchantibility and fitness for a particular purpose.
-
- This program is NOT public domain. It may be freely distributed as long
- as the following conditions are met:
-
- 1. Any and all copies must include the above copyright notice.
- 2. The software must be distributed in its original ARC format
- which contains the files DBF.COM, DBF.C, and READ.ME.
- 3. No fee may be charged for any copy, aside from a possible small
- duplication and handling fee. (I sincerely doubt you could sell
- this if you wanted to...)
-
-
- To compile the source code, you will need Turbo C (V1.0).
-
- tcc -Ic:\tc\include -Lc:\tc\lib -K -O -Z -d -f- -mt dbf.c
- exe2bin dbf.exe dbf.com
-
- For those of you without Turbo C, the command line options given to tcc
- above breakdown as follows:
-
- -I Directory for Include files
- -L Directory for Library files
- -K Default char is unsigned (should make no difference)
- -O Optimize jumps
- -Z Optimize register usage
- -d Merge duplicate strings (should make no difference)
- -f- No floating point
- -mt 'Tiny' model (one 64k code/data segment)
-
-
- If you make any significant enhancements to this program, I would
- appreciate a copy (always looking for new techniques). If you have any
- comments, suggestions and/or complaints, I can be reached online via CIS
- or BIX.
-
- Dave Love
- CIS: 75126,2223
- BIX: dlove
-
-
- Example
-
- Sample input: DBF i*
-
- Sample output:
- Structure for database : IMPORTS.DBF
- Number of data records : 471
- Date of last update : 05-16-1988
- Field Field name Type Width Dec
- ----- ---------- ---- ----- ---
- 1 FOREIGN Character 7
- 2 PO Character 7
- 3 DOCREC Character 7
- 4 DATE_RECD Date 8
- 5 MMONTH Date 8
- 6 DEPARTMENT Character 3
- 7 AREA Character 3
- 8 CARTONS Numeric 5 0
- 9 PIECES Numeric 5 0
- 10 DOLLARS Numeric 12 2
- 11 PULL_LIST Date 8
- 12 COMMENT Character 25
- 13 ORIG_MM Date 8
- 14 ORIG_RECD Date 8
- 15 DIVISION Numeric 2 0
- 16 GMM Numeric 1 0
- 17 LOC_LIST Date 8
- 18 PULL_ID Numeric 6 0
- 19 LOC_ID Numeric 6 0
- 20 PROBLEM Character 3
- 21 PROBRECD Date 8
- 22 PROBCLRD Date 8
- ** Total ** 157
-
-