Clarion Database Driver

Top  Previous  Next

Database Drivers

Choosing the Right Database Driver

Common Database Driver Features

Driver Strings

 

Clarion:Specifications

Clarion:Data Types

Clarion:File Specifications/Maximums

Clarion:Driver Strings

Clarion:Supported Commands and Attributes

Clarion:Other

 

Clarion:Specifications

The Clarion file driver is compatible with the file system used by Clarion for DOS 3.1 and Clarion Professional Developer 2.1, patch 2.109 and later.

Keys and Indexes exist as separate files from the data file. Keys are dynamic--they are automatically updated as the data file changes. The default file extension for a key file is *.K##. Indexes are static--they do not automatically update, but instead require the BUILD statement for updating.

The driver stores records as fixed length. It stores memo fields in a separate file. The memo file defaults to the first eight characters of the File Label plus an extension of .MEM.

Files:

ClaCLAL.LIB

Windows Static Link Library

 

ClaCLA.LIB

Windows Export Library

 

ClaCLA.DLL

Windows Dynamic Link Library

 

By avoiding the ASCII-only file formats of many other popular PC database application development systems, the Clarion file format provides a more secure means of storing data.

Clarion:Data Types

BYTE

DECIMAL

SHORT

STRING(255 byte maximum)

LONG

MEMO

REAL

GROUP

 

Clarion:File Specifications/Maximums

File Size:              4,294,967,295

Records per File :      4,294,967,295

Record Size:            65,520 bytes

Field Size :            65,520 bytes

Field Name:             12 characters

Fields per Record:      65,520

Keys/Indexes per File:  251

Key Size:               245 bytes

Memo fields per File :  1

Memo Field Size:        65,520 bytes

Open Data Files:        Operating system dependent

A Clarion file name (including path) cannot be longer than 79 characters.