?? dbf.htm
字號:
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=gb2312">
<title>dbf file structure</title>
<meta name="generator" content="microsoft frontpage 3.0">
</head>
<body background="../jpg/di1.JPG">
<p align="center"><font size="6" color="#0000ff">dbf file structure</font></p>
<div align="center"><center>
<table border="0" width="88%">
<tr>
<td width="100%">i am enclosing a more accurate file layout. note it include <br>
dbaseiii+, dbaseiv, foxbase, foxpro upto and including 2.6.<br>
<br>
<br>
dbf file structure<br>
~~~~~~~~~~~~~~~~~~<br>
<br>
bytes description<br>
00 foxbase+, foxpro, dbaseiii+, dbaseiv, no memo - 0x03<br>
foxbase+, dbaseiii+ with memo - 0x83<br>
foxpro with memo - 0xf5<br>
dbaseiv with memo - 0x8b<br>
dbaseiv with sql table - 0x8e<br>
<br>
01-03 last update, format yyyymmdd **correction: it is yymmdd**<br>
04-07 number of records in file (32-bit number)<br>
08-09 number of bytes in header (16-bit number)<br>
10-11 number of bytes in record (16-bit number)<br>
12-13 reserved, fill with 0x00<br>
14 dbaseiv flag, incomplete transaction<br>
begin transaction sets it to 0x01<br>
end transaction or rollback reset it to 0x00<br>
<br>
15 encryption flag, encrypted 0x01 else 0x00<br>
changing the flag does not encrypt or decrypt the records<br>
<br>
16-27 dbaseiv multi-user environment use<br>
28 production index exists - 0x01 else 0x00<br>
29 dbaseiv language driver id<br>
30-31 reserved fill with 0x00<br>
32-n field descriptor array<br>
n+1 header record terminator - 0x0d<br>
<br>
field descriptor array table<br>
bytes description<br>
0-10 field name ascii padded with 0x00<br>
11 field type identifier (see table)<br>
12-15 displacement of field in record<br>
16 field length in bytes<br>
17 field decimal places<br>
18-19 reserved<br>
20 dbaseiv work area id<br>
21-30 reserved<br>
31 field is part of production index - 0x01 else 0x00<br>
<br>
field identifier table<br>
ascii description<br>
c character<br>
d date, format yyyymmdd<br>
f floating point<br>
g general - foxpro addition<br>
l logical, t:t,f:f,y:y,n:n,?-not initialized<br>
m memo (stored as 10 digits representing the dbt block number)<br>
n numeric<br>
p picture - foxpro addition<br>
<br>
note all dbf field records begin with a deleted flag field.<br>
if record is deleted - 0x2a (asterisk) else 0x20 (space)<br>
end of file is marked with 0x1a<br>
<br>
<br>
peter mikalajunas<br>
kd9fb@xnet.com<br>
http://www.xnet.com/~kd9fb</td>
</tr>
</table>
</center></div>
<p align="center"><a href="../index.htm">返回</a></p>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -