Icon View Incident Report

Serious Serious
Reported By: Steve Forbes
Reported On: 10/8/2001
For: Version 3.02 Build 1
# 917 DBSYS Reverse-Engineering Option Not Handling Appending of Records with AutoInc Fields Properly

It appears that reverse engineering a table using the SQL-92 option on a table containing an autoinc column is not working correctly when you select to include code to add existing data .. i.e. the insert statements contains both NULL as the value of the autoinc column, and NOAUTOINC. It seems to me that there should be an option to retain existing autoinc values, so that either the existing values are brought across, or the autoinc regenerated when the SQL is executed.

It also appears that using the export to Delphi 5 or 6 code option will add records with a regenerated autoinc value (I have not tested this though), but not allow for the existing autoinc value to be kept.

Comments Comments and Workarounds
Workaround for this problem is to fix the code manually. When fixing this problem also changed the reverse-engineering code so that it no longer outputs tabs in source code, it now outputs spaces instead.

Resolution Resolution
Fixed Problem on 10/8/2001 in version 3.03 build 1