Thanks Martijn

So it will work on FireBird 2.0 ?




--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

>
>
> > 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