LastRecID Functions

Returns the last RecID inserted in the database. If dbName is specified then returns the last RecID for the specified database. Otherwise for the current database.

SELECT Last_RecID();
=> 0
SELECT Last_RecID( 'db1' );
=> 1

There are two forms:

Last_RecID_Of_Table( tblName ) Last_RecID_Of_Table( dbName, tblName )

Returns the last RecID inserted in the particular table. If dbName is specified then table is seeking in that database, otherwise in the current database.

SELECT Last_RecID_Of_Table( 't1' );
=> 0
SELECT Last_RecID_Of_Table( 'db1', 't1' );
=> 1

There are two forms:

Last_Left_RecId_Of_Link( linkname ) Last_Left_RecId_Of_Link( dbName, linkname )

Returns the last left RecID linked using linkname link. If dbName is specified then link is seeking in that database, otherwise in the current database.

SELECT Last_Left_RecId_Of_Link( 'l1' );
=> 1
SELECT Last_Left_RecId_Of_Link( 'db1', 'l1' );
=> 1

There are two forms:

Last_Right_RecId_Of_Link( linkname ) Last_Right_RecId_Of_Link( dbName, linkname )

Returns the last right RecID linked using linkname link. If dbName is specified then link is seeking in that database, otherwise in the current database.

SELECT Last_Right_RecId_Of_Link( 'l1' );
=> 1
SELECT Last_Right_RecId_Of_Link( 'db1', 'l1' );
=> 1