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.spele...@carfac.com<mailto:nico.spele...@carfac.com> |
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]
