FrontBase logo

FrontBase Documentation

FrontBase logo

    5. SQL 92
      5.3. FrontBase Datatypes
Updated: 20-Nov-2000
Table of Contents

5.3.3. Proprietary Datatypes

FrontBase implements one proprietary type:


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



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.


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

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

©2000 FrontBase, Inc. All rights reserved.