Icon View Incident Report

Serious Serious
Reported By: Fernando Dias
Reported On: 8/21/2008
For: Version 2.01 Build 4
# 2763 Altering a Foreign Key Constraint Can Cause #401 Error

I'm getting the following error when trying to alter a constraint:

ElevateDB Error #401 The index 0 does not exist

The table was created and altered by the following statements.

CREATE TABLE "TestRI" (
"Id" INTEGER,
"Nome" VARCHAR(10) COLLATE "ANSI",
"Resp" INTEGER,
CONSTRAINT "PrimaryKey" PRIMARY KEY ("Id"),
CONSTRAINT "FK" FOREIGN KEY ("Resp") REFERENCES "TestRI" ("Id") ON 
UPDATE RESTRICT ON DELETE RESTRICT
)

ALTER TABLE "TestRI" ALTER CONSTRAINT "FK" AS  FOREIGN KEY ("Resp") 
REFERENCES "TestRI" ("Id")



Resolution Resolution
Fixed Problem on 8/23/2008 in version 2.01 build 5


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image