UL Ext.: Returns the most recent identity value used.
Visual Basic Public Readonly Property LastIdentity As UInt64
C# public ulong LastIdentity { get;}
The most recently-used identity value as an unsigned long.
The most recent identity value used. This property is equivalent to the SQL Anywhere statement:
SELECT @@identity |
LastIdentity is particularly useful in the context of global autoincrement columns.
Since this property only allows you to determine the most recently assigned default value, you should retrieve this value soon after executing the insert statement to avoid spurious results.
Occasionally, a single insert statement may include more than one column of type global autoincrement. In this case, LastIdentity is one of the generated default values, but there is no reliable means to determine from which column the value is. For this reason, you should design your database and write your insert statements to avoid this situation.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |