Next: Introduction, Previous: (dir), Up: (dir) [Contents][Index]
This is the db3 Reference Manual, generated automatically by Declt version 3.0 "Montgomery Scott" on Tue Dec 22 12:13:05 2020 GMT+0.
• Introduction | What db3 is all about | |
• Systems | The systems documentation | |
• Files | The files documentation | |
• Packages | The packages documentation | |
• Definitions | The symbols documentation | |
• Indexes | Concepts, functions, variables and data types |
A lib to read dbf files version 3.
The structure of a dBASE III database file is composed of a header and data records. The layout is given below.
+---------+-------------------+---------------------------------+
| BYTE | CONTENTS | MEANING |
+---------+-------------------+---------------------------------+
| 0 | 1 byte | dBASE III version number |
| | | (03H without a .DBT file) |
| | | (83H with a .DBT file) |
+---------+-------------------+---------------------------------+
| 1-3 | 3 bytes | date of last update |
| | | (YY MM DD) in binary format |
+---------+-------------------+---------------------------------+
| 4-7 | 32 bit number | number of records in data file |
+---------+-------------------+---------------------------------+
| 8-9 | 16 bit number | length of header structure |
+---------+-------------------+---------------------------------+
| 10-11 | 16 bit number | length of the record |
+---------+-------------------+---------------------------------+
| 12-31 | 20 bytes | reserved bytes (version 1.00) |
+---------+-------------------+---------------------------------+
| 32-n | 32 bytes each | field descriptor array |
| | | (see below) | --+
+---------+-------------------+---------------------------------+ |
| n+1 | 1 byte | 0DH as the field terminator | |
+---------+-------------------+---------------------------------+ |
|
|
A FIELD DESCRIPTOR: <------------------------------------------+
+---------+-------------------+---------------------------------+
| BYTE | CONTENTS | MEANING |
+---------+-------------------+---------------------------------+
| 0-10 | 11 bytes | field name in ASCII zero-filled |
+---------+-------------------+---------------------------------+
| 11 | 1 byte | field type in ASCII |
| | | (C N L D or M) |
+---------+-------------------+---------------------------------+
| 12-15 | 32 bit number | field data address |
| | | (address is set in memory) |
+---------+-------------------+---------------------------------+
| 16 | 1 byte | field length in binary |
+---------+-------------------+---------------------------------+
| 17 | 1 byte | field decimal count in binary |
+---------+-------------------+---------------------------------+
| 18-31 | 14 bytes | reserved bytes (version 1.00) |
+---------+-------------------+---------------------------------+
Data records are preceeded by one byte that is a space (20H) if the record is not deleted and an asterisk (2AH) if it is deleted.
Data fields are packed into records with no field separators or record terminators.
Data types are stored in ASCII format as follows:
DATA TYPE DATA RECORD STORAGE
--------- --------------------------------------------
Character (ASCII characters)
Numeric - . 0 1 2 3 4 5 6 7 8 9
Logical ? Y y N n T t F f (? when not initialized)
Memo (10 digits representing a .DBT block number)
Date (8 digits in YYYYMMDD format, such as
19840704 for July 4, 1984)
-----------------------------------------------------------
Dbase memo files seem to be like their own kind of fun. Initial attempt at providing support for them has been hacked together for dBase III+ versions. dBase IV are said to be using a different formating, with per-block block size and type.
Next: Files, Previous: Introduction, Up: Top [Contents][Index]
The main system appears first, followed by any subsystem dependency.
• The db3 system |
Xach
WTFPL
DB3 file reader
db3.asd (file)
Files are sorted by type and then listed depth-first from the systems components trees.
• Lisp files |
• The db3.asd file | ||
• The db3/package.lisp file | ||
• The db3/db3.lisp file |
Next: The db3/package․lisp file, Previous: Lisp files, Up: Lisp files [Contents][Index]
db3.asd
db3 (system)
Next: The db3/db3․lisp file, Previous: The db3․asd file, Up: Lisp files [Contents][Index]
Previous: The db3/package․lisp file, Up: Lisp files [Contents][Index]
db3 (system)
db3.lisp
Next: Definitions, Previous: Files, Up: Top [Contents][Index]
Packages are listed by definition order.
• The db3 package |
package.lisp (file)
common-lisp
Definitions are sorted by export status, category, package, and then by lexicographic order.
• Exported definitions | ||
• Internal definitions |
Next: Internal definitions, Previous: Definitions, Up: Definitions [Contents][Index]
• Exported special variables | ||
• Exported functions | ||
• Exported generic functions | ||
• Exported classes |
Next: Exported functions, Previous: Exported definitions, Up: Exported definitions [Contents][Index]
External format of the DBF file Character data
Next: Exported generic functions, Previous: Exported special variables, Up: Exported definitions [Contents][Index]
Next: Exported classes, Previous: Exported functions, Up: Exported definitions [Contents][Index]
Previous: Exported generic functions, Up: Exported definitions [Contents][Index]
db3.lisp (file)
standard-object (class)
:filename
filename (generic function)
(setf filename) (generic function)
memo (generic function)
(setf memo) (generic function)
version-number (generic function)
(setf version-number) (generic function)
last-update (generic function)
(setf last-update) (generic function)
record-count (generic function)
(setf record-count) (generic function)
header-length (generic function)
(setf header-length) (generic function)
record-length (generic function)
(setf record-length) (generic function)
encoding (generic function)
(setf encoding) (generic function)
fields (generic function)
(setf fields) (generic function)
Previous: Exported definitions, Up: Definitions [Contents][Index]
• Internal special variables | ||
• Internal functions | ||
• Internal generic functions | ||
• Internal classes |
Next: Internal functions, Previous: Internal definitions, Up: Internal definitions [Contents][Index]
Next: Internal generic functions, Previous: Internal special variables, Up: Internal definitions [Contents][Index]
Next: Internal classes, Previous: Internal functions, Up: Internal definitions [Contents][Index]
automatically generated reader method
db3.lisp (file)
automatically generated writer method
db3.lisp (file)
automatically generated reader method
db3.lisp (file)
automatically generated writer method
db3.lisp (file)
db3.lisp (file)
db3.lisp (file)
db3.lisp (file)
db3.lisp (file)
db3.lisp (file)
db3.lisp (file)
db3.lisp (file)
db3.lisp (file)
automatically generated reader method
db3.lisp (file)
automatically generated writer method
db3.lisp (file)
automatically generated reader method
db3.lisp (file)
automatically generated writer method
db3.lisp (file)
Previous: Internal generic functions, Up: Internal definitions [Contents][Index]
db3.lisp (file)
standard-object (class)
field-name (generic function)
(setf field-name) (generic function)
field-type (generic function)
(setf field-type) (generic function)
data-address (generic function)
(setf data-address) (generic function)
field-length (generic function)
(setf field-length) (generic function)
field-count (generic function)
(setf field-count) (generic function)
db3.lisp (file)
standard-object (class)
:filename
filename (generic function)
(setf filename) (generic function)
db3-memo-stream (generic function)
(setf db3-memo-stream) (generic function)
next-block (generic function)
(setf next-block) (generic function)
block-size (generic function)
(setf block-size) (generic function)
db3.lisp (file)
standard-object (class)
block-type (generic function)
(setf block-type) (generic function)
block-size (generic function)
(setf block-size) (generic function)
:data
block-data (generic function)
(setf block-data) (generic function)
Previous: Definitions, Up: Top [Contents][Index]
• Concept index | ||
• Function index | ||
• Variable index | ||
• Data type index |
Next: Function index, Previous: Indexes, Up: Indexes [Contents][Index]
Jump to: | D F L |
---|
Jump to: | D F L |
---|
Next: Variable index, Previous: Concept index, Up: Indexes [Contents][Index]
Jump to: | (
A B C D E F G H I L M N R S U V W |
---|
Jump to: | (
A B C D E F G H I L M N R S U V W |
---|
Next: Data type index, Previous: Function index, Up: Indexes [Contents][Index]
Jump to: | *
B D E F H L M N R S T V |
---|
Jump to: | *
B D E F H L M N R S T V |
---|
Previous: Variable index, Up: Indexes [Contents][Index]
Jump to: | C D P S |
---|
Jump to: | C D P S |
---|