5. SQL 92
5.3. FrontBase Datatypes
Table of Contents
FrontBase implements one proprietary type:
The type is explained below with an example of defining a column of the type.
BYTEA simple wrapper for
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 firstname.lastname@example.org. Please reference the section number and topic. Thanks!!
©2000 FrontBase, Inc. All rights reserved.