Scribd
Upload
14 views6 pages

dBASE Version 7 File Structure Guide

The document describes the header structure and field properties for dBASE version 7 table files. Key points include: - The table file header includes information like the database type, date of last update, and record count. - The field descriptor array describes each field's name, type, and other properties. - Additional structures store field constraints, custom properties, and referential integrity rules. - Common field types include character, numeric, logical, date, memo, and OLE fields, which can be stored directly in the table or indirectly in an external .DBT file.

Uploaded by

xslim001
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
14 views6 pages

dBASE Version 7 File Structure Guide

The document describes the header structure and field properties for dBASE version 7 table files. Key points include: - The table file header includes information like the database type, date of last update, and record count. - The field descriptor array describes each field's name, type, and other properties. - Additional structures store field constraints, custom properties, and referential integrity rules. - Common field types include character, numeric, logical, date, memo, and OLE fields, which can be stored directly in the table or indirectly in an external .DBT file.

Uploaded by

xslim001
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Data File Header Structure for the

dBASE Version 7 Table File


Note: U
.

"0 ",

1.1 Table File Header


B te

Contents

Description
V
5, 4

BASE
W
BASE L

B 3
4-6
.DBT

0-2

:3

BASE L

7.
BASE IV
BASE IV SQL
BASE III PLUS

BASE
W
7
BASE IV
BASE

;
W

).
1-3

4-7
8-9
1011

3
321616-

D
YY

YYMMDD
1900
0 00-0 FF,

.
.T
1900-2155.

. (L

.)

. (L

.)

. (L

.)

1213

14

15

1627

12

28

29

3031

3263

32

6467

BASE IV

BASE IV
MDX

.
; 0 01

.MDX

ID.
;

.
.

.
D

R
P

, YY

48
68-

. E

1.2).

; 0 00

.MDX

+1 1

0 0D

S
+2

.T
.

1. 2 Field Descriptor Arra


(O

B te Contents
0-31 32

Description
F

32

33

34

3536

37

3839

4043

4447

ASCII (

).

ASCII (B, C, D, N, L, M, @, I, +, F, 0

G).

.
.
.

.MDX

; 0 01

.MDX

.
.
A

, 0 00

1.3 Field Properties Structure


T
(S

F
.DBF

.I
1.1).

,
F

B te Contents
0-1
2-3
4-5
6-7
8-9
10-11

161616161616-

Description
N
S

S
S

N
S

P
C

D
P

RI P

D
I
D

.(

1.3.1 )

A
(RI)
A

.(

1.3.2 )
.

.(

1.3.3 )

,
D

; 0 00

16-

12-13

16-

14-15
16-

(N
0 1A

0 200,
.

15

S
1.3.1)

( +1)- 14

( +1)- 22

RI P

D
D

A
A

( =

.DBF
). I

RI

( = (15*
(

) + 16). (

= + 14*

). (

+ 22*

RI

). (

1.3.2)

1.3.3)

1.3.1 Standard Propert and Constraint Descriptor Arra


B te Contents
0-1
2-3

16-

Description
G

.M

.T
.

16-

T
N

. 01

, 02

01 R
8-

02 M
03 M
04 D
06 D
F

00 N

01 C
02 N
03 M
04 L
5

05 D
06 F
08 OLE
09 B
11 L
12 T
13 D
14 A

0 00

7-10

1112

16-

1314

16-

, 0 02

.T
,

W
0

0.
,
).

1.3.2 Custom Propert Descriptor Arra


B te Contents
0-1
2-3

16-

Description
G

.M

.T
.

16-

. 01

, 02

01 C
02 N
03 M
04 L
05 D
4

06 F
08 OLE
09 B
11 L
12 T
13 D
14 A

5
6-7
8-9

1616-

1011

16-

1213

16-

).

1.3.3 Referential Integrit Propert Descriptor Arra


B te
0
1-2
3-4
5-6
7-8
9-10

Contents
8-

Description
0 07

16-

), 0 08

,1

).

.I

0,

.
16161616-

O
S

RI

-0
.

O
S

F
.

-0

RI

11

1213

16-

1415

16-

1617

16-

1819

16-

2021

16-

(F

&

U
D

C
C

0 10
0 01

-0

-0

, L

Propert Data
F

,
N

T
,

.C
,

.T

Table Records
T

.D
(0 2A)
.T
26 (0 1A).

,
,

OEM

(0 20)

.F
,

- -

Storage of dBASE Data T pes


E

.I

.
S mbol

Data T pe
B

Description
10

.DBT

.T

A OEM
D

YYYYMMDD.
,

1
,

10

0 20 (
(

8
T

.DBT

F.
.T

.
,
01/01/4713 BC. T

. T
* 3600000L +

* 60000L + S

1000L
I
+

L
A

4
S

.L

,0
L

,
.
-

8
10

OLE

,
(

.
.DBT

.T
.

Binar , Memo, OLE Fields and .DBT Files


B

,
,
OLE
.). SET BLOCKSIZE
.DBT
.
E

.DBT

OLE

.DBF
.I

'

(0 20)
W

(0, 1, 2,
.T

.DBT

0,

(
,

.DBF

.
,

.DBF
.

OEM

You might also like