Reported By: Elevate Software Reported On: 11/18/2004 For: Version 4.14 Build 1
# 1904LASTAUTOINC and IDENT_CURRENT SQL Functions Returning Incorrect Result The LASTAUTOINC and IDENT_CURRENT SQL functions are not returning the correct last auto-increment number for the given table.
Comments and WorkaroundsThe workaround is to use the TDBISAMTable.LastAutoIncValue property to get the last autoinc value for a table, or to use a MAX() SELECT query on the autoinc column in question.
ResolutionFixed Problem on 11/19/2004 in version 4.15 build 1