<< Click to Display Table of Contents >> Navigation:  SQL Reference > Functions and Operators > System Functions

 

LASTAUTOINC ( [MEMORY] table_name, field_name)

Returns the last autoinc value for the field_name autoinc field from the table table_name, which was inserted within the last session.

Example:

SELECT LastAutoinc(venues, venueno) FROM venues

__________________________
Absolute SQL Reference - 05 January 2023, Niels Knabe