FrontBase Documentation

Backtrack:
  Welcome!
    5. SQL 92
      5.3. FrontBase Datatypes
Updated: 20-Nov-2000
prev — next
Table of Contents

5.3.3. Proprietary Datatypes

FrontBase implements one proprietary type:

BYTE

The type is explained below with an example of defining a column of the type.

BYTE

A simple wrapper for BIT. BYTE(n) is identical to BIT(n*8). This dataype is not part of the SQL 92 standard, but has been introduced to better support EOF's automatic primary key generation. If you use 12-byte binary key's, EOF can automatically generate a primary key without doing a roundtrip to the database server and thus initiate a transaction.
Example:

CREATE TABLE T0(C0 BYTE(12), ...);

If you have feedback or questions on this document, please send e-mail to doc-feedback@frontbase.com. Please reference the section number and topic. Thanks!!