Basic Database Driver

Top  Previous  Next

Database Drivers

Choosing the Right Database Driver

Common Database Driver Features

Driver Strings

 

Basic:Specifications

Basic:Supported Data Types

Basic:File Specifications/Maximums

Basic:Driver Strings

Basic:Supported Commands and Attributes

 

Basic:Specifications

The BASIC file driver reads and writes comma-delimited ASCII files. By default, quotes ( " " ) surround strings, commas delimit fields, and a carriage-return/line-feed delimits records. The original BASIC programming language defined this file format. The Basic driver does not support keys or backward file processing (thus Basic files are not a good choice for random access processing).

 

The Basic file format provides a good choice for a common file format for sharing data with spreadsheet programs. A common file extension used for these files is *.CSV, which stands for "comma separated values."

Files:

ClaBASL.LIB

Windows Static Link Library (32-bit)

 

ClaBAS.LIB

Windows Export Library (32-bit)

 

ClaBAS.DLL

Windows Dynamic Link Library (32-bit)

Basic:Supported Data Types

BYTE

DECIMAL

SHORT

PDECIMAL

USHORT

STRING

LONG

CSTRING

ULONG

PSTRING

SREAL

DATE

REAL

TIME

BFLOAT4

GROUP

BFLOAT8

 

Basic:File Specifications/Maximums

File Size:             4 GB

Records per File:      4,294,967,295 bytes

Record Size:           65,520 bytes

Field Size:            65,520 bytes

Fields per Record:     65,520

Keys/Indexes per File: n/a

Key Size:              n/a

Memo fields per File:  0

Memo Field Size:       n/a

Open Data Files:       Operating system dependent