Interbase GUID Usage Example

IBGUIDExample.pas

/* Domain definitions */
CREATE DOMAIN ENTITYNAME AS VARCHAR(36) CHARACTER SET UTF8 NOT NULL;
CREATE DOMAIN ENTRYINACTIVE AS BOOLEAN
	 DEFAULT False NOT NULL;
CREATE DOMAIN ID_GUID AS CHAR(16) CHARACTER SET OCTETS NOT NULL;

/* Table: CM_CLIENTMASTER, Owner: SYSDBA */
CREATE TABLE CM_CLIENTMASTER 
(
        CM_ID	ID_GUID NOT NULL,
        CM_NAME	ENTITYNAME NOT NULL,
        CM_INACTIVE	ENTRYINACTIVE  DEFAULT False NOT NULL,
CONSTRAINT PK_CM_CLIENTMASTER PRIMARY KEY (CM_ID)
);