Icon View Incident Report

Minor Minor
Reported By: Terry Swiers
Reported On: 2/2/2010
For: Version 2.03 Build 8
# 3145 ElevateDB Manager Reverse-Engineering Incorrect For Databases without Tables

Next time you are in the edbreverse unit, there are two tweaks that are needed to get it operating correctly. Actually the tweak is the same for both areas.

In the "Reverse-engineering functions" and "Reverse-engineering procedures", these sections can pass through to the AddSQLStatement(TempSQL) call even if the TempSQL variable isn't set. So in my case, it was inserting in an additional create table statement for the last table added to the database for each function in the database definition. Thus it was
throwing table already exists errors during restructures.

My solution was to set TempSQL = '' before the conditions are checked and then add "if (TempSQL <> '') then" before the AddSQLStatement call.


Resolution Resolution
Fixed Problem on 2/13/2010 in version 2.03 build 9


Products Affected Products Affected
ElevateDB Additional Software and Utilities

Image