Icon View Incident Report

Serious Serious
Reported By: Michael Baytalsky
Reported On: 2/16/2007
For: Version 1.00 Build 1
# 2231 Defining Circular Foreign Key Constraints Causes a Lock Error

The following sequence (batch) produces error in the second statement:

Error: ElevateDB Error #300 Cannot lock table Projects for exclusive access

ALTER TABLE "Projects"
  ADD CONSTRAINT "CurrectProject_CurrentVersion" FOREIGN KEY ("CurrentVersion")
  REFERENCES "Versions"("VersionID")

ALTER TABLE "Versions"
  ADD CONSTRAINT "Versions_Project" FOREIGN KEY ("ProjectID")
  REFERENCES "Projects"("ProjectID")



Resolution Resolution
Fixed Problem on 2/16/2007 in version 1.01 build 1


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

Image