FrontBase logo

FrontBase Documentation

FrontBase logo

Backtrack:
  Welcome!
    5. SQL 92
      5.3. FrontBase Datatypes
Updated: 20-Nov-2000
prevnext
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!!

©2000 FrontBase, Inc. All rights reserved.