📄 dbf.htm

📁 各种文件格式说明及程序描述
💻 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&nbsp;&nbsp;&nbsp; foxbase+, foxpro, dbaseiii+, dbaseiv, no memo - 0x03<br>
foxbase+, dbaseiii+ with memo - 0x83<br>
&nbsp;&nbsp;&nbsp; foxpro with memo - 0xf5<br>
&nbsp;&nbsp;&nbsp; dbaseiv with memo - 0x8b<br>
&nbsp;&nbsp;&nbsp; dbaseiv with sql table - 0x8e<br>
<br>
01-03 last update, format yyyymmdd **correction: it is yymmdd**<br>
04-07&nbsp;&nbsp;&nbsp; number of records in file (32-bit number)<br>
08-09&nbsp;&nbsp;&nbsp; number of bytes in header (16-bit number)<br>
10-11&nbsp;&nbsp;&nbsp; number of bytes in record (16-bit number)<br>
12-13&nbsp;&nbsp;&nbsp; reserved, fill with 0x00<br>
14&nbsp;&nbsp;&nbsp; dbaseiv flag, incomplete transaction<br>
begin transaction sets it to 0x01<br>
&nbsp;&nbsp;&nbsp; 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&nbsp;&nbsp;&nbsp; production index exists - 0x01 else 0x00<br>
29&nbsp;&nbsp;&nbsp; dbaseiv language driver id<br>
30-31 reserved fill with 0x00<br>
32-n&nbsp;&nbsp;&nbsp; field descriptor array<br>
n+1&nbsp;&nbsp;&nbsp; header record terminator - 0x0d<br>
<br>
field descriptor array table<br>
bytes description<br>
0-10 field name ascii padded with 0x00<br>
11&nbsp;&nbsp;&nbsp; field type identifier (see table)<br>
12-15&nbsp;&nbsp;&nbsp; displacement of field in record<br>
16&nbsp;&nbsp;&nbsp; field length in bytes<br>
17&nbsp;&nbsp;&nbsp; field decimal places<br>
18-19&nbsp;&nbsp;&nbsp; reserved<br>
20&nbsp;&nbsp;&nbsp; dbaseiv work area id<br>
21-30&nbsp;&nbsp;&nbsp; reserved<br>
31&nbsp;&nbsp;&nbsp;&nbsp; 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 + -