# 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.