Must perform the same function as the @@identity in a MS SQL server database.

Upgrade to version 9 - this is one of the language enhancements:

GETAUTOINCVALUE([nDataSessionNumber | 0])

Returns the last value generated for an autoincremented field within a data session.

Parameters

nDataSessionNumber

Specifies the data session number of the data session for which the autoincremented field value is returned. The autoincremented field value is returned for the current data session if you omit the nDataSessionNumber and 0 parameters. Use SET DATASESSION to activate a specific data session.

0

Specifies that the autoincremented field value is returned from within the scope of the current function, procedure, or method.

Return Value
Numeric data type. The value returned by GETAUTOINCVALUE( ) is the last autoincrement value generated, even if a field was not successfully updated with the autoincrement value. .NULL. is returned if an autoincrement value hasn't yet been