--- In [email protected], "dennis" <[EMAIL PROTECTED]> wrote: > The follow index didn't have problem prior to firebird version 2.0.3.12981
Precisely what version did you have before? Is there anything in the change log or the release notes that hints at what changed? > CREATE INDEX CODES_IDX2 ON CODES (KEY_, RES_); > > The error message is: > > This operation is not defined for system tables. > > unsuccessful metadata update. > > key size exceeds implementation restriction for index "CODES_IDX2". > > > > Key_ and res_ fields are varchar(100). Doesn't the size that that represents vary based on the character set you're using? > What happen? Does 2.0.3.12981 version requires smaller instead or bigger > index keys? Where am I wrong? Your question seems to be one about Firebird, not Delphi. Have you tried asking in a Firebird forum? -- Rob
