Icon View Incident Report

Minor Minor
Reported By: Rony Gellaerts
Reported On: 6/15/2011
For: Version 2.05 Build 9
# 3471 ElevateDB Manager Statement Selection Not Working Properly in Generic Scripts

I have made an reversed engineered sql file from my database. However, when i execute the file in a new database, i get the following error:

"ElevateDB Error #100 There is an error in the metadata for the table Documenten in the schema Default (No candidate keys exist in the Documenten table for the foreign key columns [Document_ID])"

When i copy the following line from the rev.eng. file and execute it in a new sql editor window, the rest of the rev.eng. file executes further.

ALTER TABLE "Documenten" 
ADD CONSTRAINT "Document_ID" PRIMARY KEY ("Document_ID")!



Comments Comments
The issue was with generic script execution in the ElevateDB Manager. Generic script execution (with statement terminators) relies on statement selection to individually execute each statement in succession. This wasn't working propely in certain cases, and would cause this single statement to be skipped.


Resolution Resolution
Fixed Problem on 6/16/2011 in version 2.05 build 10


Products Affected Products Affected
ElevateDB Additional Software and Utilities

Image