Hello,

I have a problem with inserting a row in table OrderTypeDescriptions. Here you can find the sql script for the tables OrderTypes and OrderTypeDescriptions.


CREATE TABLE ORDERTYPES (

ID INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL,

STOCKORDER BOOLEAN DEFAULT FALSE NOT NULL,

ROWVERSION TIMESTAMP,

/* Keys */

CONSTRAINT PK_ORDERTYPES

PRIMARY KEY (ID)

);



CREATE TABLE ORDERTYPEDESCRIPTIONS (

ID INTEGER GENERATED BY DEFAULT AS IDENTITY NOT NULL,

ORDERTYPEID INTEGER NOT NULL,

ORDERTYPEDESCRIPTION VARCHAR(100) COLLATE UNICODE_CI_AI,

LANGUAGEID INTEGER NOT NULL,

ROWVERSION TIMESTAMP,

/* Keys */

CONSTRAINT PK_ORDERTYPEDESCRIPTIONS

PRIMARY KEY (ID),

/* Foreign keys */

CONSTRAINT FK_ORDERTYPEDESC_LANGUAGEID

FOREIGN KEY (LANGUAGEID)

REFERENCES LANGUAGES(ID)

ON DELETE CASCADE,

CONSTRAINT FK_ORDERTYPEDESC_ORDERTYPEID

FOREIGN KEY (ORDERTYPEID)

REFERENCES ORDERTYPES(ID)

ON DELETE CASCADE

);



CREATE INDEX IX_ORDERTYPEDESC_DESCRIPTION

ON ORDERTYPEDESCRIPTIONS

(ORDERTYPEID, LANGUAGEID);

If I insert a row in table OrderType there is no problem.
Id = 1
Stockorder = true

If I post a new row in table OrderTypeDescriptions I got a problem

Problem
Engine Error (code = 335544333): internal Firebird consistency check (partner index description not found (175), file: idx.cpp line: 1271).
SQL error (code = -902): Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements.

Nico Speleers
Team Lead Analyse & Consultancy





Carfac bvba

[Beschrijving: Beschrijving: Beschrijving: CarfacAS (klein)]<http://www.carfac.be/>Driving on experience


Ambachtstraat 8 | 9700 Oudenaarde
Tel. +32 55 23 00 00 | Fax +32 55 31 00 95
nico.speleers@...<mailto:nico.speleers@...> | www.carfac.be<http://www.carfac.be/>

[Facebook]<http://www.facebook.com/groups/120709181286476/>[LinkedIn]<http://www.linkedin.com/company/hdc-software-nv>[Twitter]<https://twitter.com/carfacbvba>






[Non-text portions of this message have been removed]