System Functions

<< Click to Display Table of Contents >>

Navigation:  SQL Reference > Functions and Operators >

System Functions

Previous pageReturn to chapter overviewNext page

 

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 - 25 May 2022, Niels Knabe