TMSDataSetOptions.LastIdentityValueFunction Property

Determines which system function to use to obtain an identifier when adding a record. The default value is vfScopeIdentity.

Class

TMSDataSetOptions

Syntax

property LastIdentityValueFunction: TMSLastIdentityValueFunction default vfScopeIdentity;

Remarks

Use the LastIdentityValueFunction property to determine which system function to use to obtain an identifier when adding a record.

The possible values are:

vfIdentCurrent - The IDENT_CURRENT system function is used. It returns the last identity value generated for a specified table or view. The last identity value generated can be for any session and any scope.

vfIdentity - The @@IDENTITY system function is used. It returns the last-inserted identity value.

vfScopeIdentity - The SCOPE_IDENTITY system function is used. It returns the last identity value inserted into an identity column in the same scope. A scope is a module: a stored procedure, trigger, function, or batch.