Subject | Unable to create a table with primary key field as VARCHAR of length 255 |
---|---|
Author | mpp12310 |
Post date | 2012-03-20T15:26:17Z |
Hi,
When I try to create a table with the Primary Key field being VARCHAR of length 255, and run Compile, I get an error with:
SQL Code = -607
IBError Number: 335544351
I checked my Database page size and it is 4096 (default).
I am running FB Server 2.1.4.18393 on WinXP SP3.
I am using SQL Manager Lite for Interbase/Firebird and I am using FlameRobin 0.9.3.2188; the error happens on both GUI managers.
Does anyone else get this error and how did you resolve it?
Many thanks in advance,
Michael
When I try to create a table with the Primary Key field being VARCHAR of length 255, and run Compile, I get an error with:
SQL Code = -607
IBError Number: 335544351
I checked my Database page size and it is 4096 (default).
I am running FB Server 2.1.4.18393 on WinXP SP3.
I am using SQL Manager Lite for Interbase/Firebird and I am using FlameRobin 0.9.3.2188; the error happens on both GUI managers.
Does anyone else get this error and how did you resolve it?
Many thanks in advance,
Michael