> CREATE TABLE ispFmt10 (RCA SMALLINT DEFAULT 1 NOT NULL,DORD VARCHAR
> (1) NOT NULL,DNME VARCHAR(100),MMOD VARCHAR(50) NOT NULL,MODL VARCHAR
> (50) NOT NULL,SMOD VARCHAR(50) NOT NULL,CurrOpt VARCHAR(1) NOT
> NULL,DTYP VARCHAR(3) NOT NULL,SID INTEGER DEFAULT 0 NOT NULL,SNODE
> VARCHAR(50),FL1 VARCHAR(50),FLDFR VARCHAR(50),MDBN VARCHAR(50),LnkMdb
> VARCHAR(50),LKT VARCHAR(50) PRIMARY KEY
> (RCA,DORD,MODL,MMOD,SMOD,DTYP,SID))
>
> While Executing the query it gives the following error
>
> key size too big for index RDB$PRIMARY13.

Well, the server is right, assuming Firebird < 2.



With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com