PrestwoodBoards Knowledgebase: portal.prestwood.com/ASPSuite/kb/

www.prestwoodboards.com

  From the March 2016 Issue of Prestwood eMag
 
DBA & Data:
dBASE Table Specification
 
Posted 11/19/2002 on 11/19/2002
Take Away: Description of dBASE IV field types

KB100056

dBASE IV Table Specification

The dBASE IV table format was introduced in dBASE IV for DOS. Following are the specifications for dBASE IV tables.

  • 2GB file size.

  • Two billion records per file.

  • A maximum of 255 fields per record.

  • Maintained indexes can have up to 47 indexes per file. Each index can be created using field expressions of virtually any combination, including conditional expressions of up to 255 characters per expression that result in an index of up to 100 bytes.

  • Unlimited nonmaintained indexes can be stored on disk. You can use up to 47 of them simultaneously.

dBase V Table Specifications

The dBASE V table format was introduced in dBASE V for Windows. Following are the specifications for dBASE V tables.

  • Up to one billion records per file.

  • A maximum of 1,024 fields per record.

  • Up to 32,767 bytes per record.

  • Unlimited nonmaintained indexes can be stored on disk. You can use up to 47 of them simultaneously.

  • Up to 10 master index files open per database. Each master index can have up to 47 indexes.

  • Maintained indexes can have up to 47 indexes per file. Each index can be created using field expressions of virtually any combination, including conditional expressions of up to 255 characters per expression that result in an index of up to 100 bytes.

dBASE Field Types

Character (C)

dBASE III+, IV, and V field type that can contain up to 254 characters (including blank spaces). This field is similar to the Paradox Alpha field type.

Date (D)

Paradox 3.5, 4, 5, and 7 as well as dBASE III+, IV, and V. dBASE tables can store dates from January 1, 100, to December 31, 9999. Paradox 5 tables can store from 12/31/9999 B.C. to 12/31/9999 A.D.

Float (F)

dBASE IV, and V floating-point numeric field type provides up to 20 significant digits.

Logical (L)

Paradox 5 and 7 and dBASE III+, IV, and V field type can store values representing True or False (yes or no). By default, valid entries include T and F (case is not important).

Memo (M)

Paradox 4, 5, and 7 as well as dBASE III+, IV, and V field. A Paradox field type is an Alpha variable-length field up to 256MB per field. dBASE Memo fields can contain binary as well as memo data.

OLE (O)

Paradox 1, 5, and 7 as well as dBASE V field type that can store OLE data.

Number (N)

Paradox 3.5, 4, 5, and 7 as well as dBASE III+, IV, and V field type can store up to 15 significant digits -10307 to + 10308 with up to 15 significant digits.

dBASE number fields contain numeric data in a Binary Coded Decimal (BCD) format. Use number fields when you need to perform precise calculations on the field data. Calculations on number fields are performed more slowly but with greater precision than are calculations on float number fields. The size of a dBASE number field can be from 1 to 20. Remember, however, that BCD is in Paradox 5 and 7 only for compatibility and is mapped directly to the Number field type.

Short (S)

Paradox 3.5, 4, 5, and 7 field type that can contain integers from -- 32,767 through 32,767 (no decimal).


Comments

1 Comments.
Share a thought or comment...
Comment 1 of 1
Please also specify the field width limits for dBase IV to dBase VII
Posted 6/25/2003
KB Post Contributed By Mike Prestwood:

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

Visit Profile
www.prestwoodboards.com
Copyright (C) Prestwood IT Solutions.
All Rights Reserved.
Printed 8/17/2019