Guten Tag Daniel,

> Sorry I am answering so late, was in two meetings.
> No, I deleted the irrelevant fields for simplicity. Please find below
> the DDL generated via FlameRobin.

i have not been following the discussion , but what characterset do
you use, ?
possibly your varchar 32000 are exceedig the limit ,
the Limit is not 32000 characters , but 3276? bytes , so depending on
characterset used you may only have 10920 or so chars

> Best regards
> Daniel
> -----------------------------------------------

> CREATE TABLE RELATION(
> KEYWORDID ID NOT NULL,
> ORIGINATINGOBJECTID Numeric(18,0),
> RELATEDOBJECTID Numeric(18,0),
> TARGETNAME Varchar(80),
> ROLEID Smallint NOT NULL,
> DESCRIPTIONID Smallint,
> STARTDATE Date,
> ENDDATE Date,
> NOTE Varchar(32000),
> NOTEPRIVATE Varchar(32000),
> PERCENTAGE Decimal(5,2),
> BFLAG Smallint DEFAULT 0,
> DATAEXCHANGEKEY DEK,
> DATAEXCHANGEDATE Timestamp,
> CODE Varchar(12),
> PRIMARY KEY (KEYWORDID)
> );
> ALTER TABLE RELATION ADD CONSTRAINT FK_RELATION_REF_26879_SYS_11
> FOREIGN KEY (ORIGINATINGOBJECTID) REFERENCES SYS_KEYWORD
> (KEYWORDID) ON DELETE CASCADE;
> ALTER TABLE RELATION ADD CONSTRAINT FK_RELATION_REF_26879_SYS_KEYW
> FOREIGN KEY (RELATEDOBJECTID) REFERENCES SYS_KEYWORD (KEYWORDID) ON
> DELETE CASCADE;
> ALTER TABLE RELATION ADD CONSTRAINT FK_RELATION_REF_95400_RELATION
> FOREIGN KEY (ROLEID) REFERENCES RELATIONROLE_OLU (ID);
> ALTER TABLE RELATION ADD CONSTRAINT FK_RELATION_REF_95404_RELATION
> FOREIGN KEY (DESCRIPTIONID) REFERENCES RELATIONDESCRIPTION_OLU (ID);
> ALTER TABLE RELATION ADD CONSTRAINT FK_RELATION_REF_95626_SYS_KEYW
> FOREIGN KEY (KEYWORDID) REFERENCES SYS_KEYWORD (KEYWORDID) ON
> DELETE CASCADE;
> GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE
> ON RELATION TO "NETWORK" WITH GRANT OPTION;
> GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE
> ON RELATION TO "SYSDBA" WITH GRANT OPTION;
> ----------------------------------------------------------

> CREATE TABLE SYS_KEYWORD(
> KEYWORDID ID NOT NULL,
> FULLNAME Varchar(100),
> ENTITYCLASSID Numeric(18,0),
> DATAEXCHANGEKEY DEK,
> PRIMARY KEY (KEYWORDID)
> );
> ALTER TABLE SYS_KEYWORD ADD CONSTRAINT FK_SYS_KEYW_REF_SYS_ENTITYCLS
> FOREIGN KEY (ENTITYCLASSID) REFERENCES SYS_ENTITYCLASS_LU (ID);
> GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE
> ON SYS_KEYWORD TO "NETWORK" WITH GRANT OPTION;
> GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE
> ON SYS_KEYWORD TO "SYSDBA" WITH GRANT OPTION;
> ----------------------------------------------------------

> CREATE TABLE SYS_ENTITYCLASS_LU(
> ID Numeric(18,0) NOT NULL,
> NAME Varchar(1600),
> NAMEUI Varchar(250),
> TABLEID Smallint NOT NULL,
> PRIMARY KEY (ID)
> );
> ALTER TABLE SYS_ENTITYCLASS_LU ADD CONSTRAINT
> FK_SYS_ENTI_REF_26695_SYS_TABL
> FOREIGN KEY (TABLEID) REFERENCES SYS_TABLE_LU (ID);
> GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE
> ON SYS_ENTITYCLASS_LU TO "NETWORK" WITH GRANT OPTION;
> GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE
> ON SYS_ENTITYCLASS_LU TO "SYSDBA" WITH GRANT OPTION;
> ----------------------------------------------------------





> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !

> Also search the knowledgebases at http://www.ibphoenix.com

> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links

--
Mit freundlichen Grüssen
Hannes Streicher mailto:HStreicher@...