TIP: Click on subject to list as thread! ANSI
echo: c_plusplus
to: NATHAN SEELEY
from: STEVEN READ
date: 1997-07-22 07:33:00
subject: Dbase 2/2

(Continued from previous message)
16       1 byte        Field length in binary
17       1 byte        Field decimal count in binary
18-19    2 bytes       Reserved
20       1 byte        Work area ID
21-30    10 bytes      Reserved
31       1 byte        Production .mdx field flag; 01H if field has an
                       index tag in the production .mdx file, 00H if not
Database Records
The records follow the header in the database file. Data records are
preceded by one byte; that is, a space (20H) if the record is not
deleted, an asterisk (2AH) if the record is deleted. Fields are packed
into records without field seperators or record terminators. The end of
the file is marked by a single byte, with the end-of-file marker an
ASCII 26 (1AH) character.
Data type          Record storage format
C (Character)      All ASCII characters
D (Date)           Numbers and a character to seperate month, day, and year
                   (stored internally as 8 digits in YYYYMMDD format)
F (Floating point  - . 0 1 2 3 4 5 6 7 8 9
  binary numeric)
L (Logical)        ? Y y N n T t F f (?, if not initialized)
M (Memo)           All ASCII characters (stored internally as 10 digits
                   representing a .dbt block number)
N (Binary coded    - . 0 1 2 3 4 5 6 7 8 9
  decimal numeric)
Memo Fields and the .dbt File
A memo (.dbt) file consists of blocks numbered sequentially (0, 1, 2,
and so on). SET BLOCKSIZE determines the size of each block. The first
block in the memo file, block 0, is the memo file header.
Each memo field of each record in the .dbf file contains the number of
the block (in ASCII) where the memo field begins. If the memo field
contains no data, the .dbt file contains blanks (20H) rather than a
number.
When data is changed in a memo field, the block numbers will also
change, and the number of the .dbf may be changed to reflect the new
location.
Unlike dBASE III PLUS, if you delete text in a memo field, dBASE IV may
reuse the space from the deleted text when you input new text. dBASE III
PLUS always appended new text to the end of the .dbt file. In dBASE III
PLUS, the .dbt file size grew whenever new text was added, even if other
text in the file was deleted.
========================================================================
End of message.
---
 * QMPro 1.53 * steven  read  pcohio  com
--- InterEcho 1.19
---------------
* Origin: PC-Ohio PCBoard * Cleveland, OH * 216-381-3320 (1:157/200)

SOURCE: echomail via exec-pc

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.