SQL::Connection::GenerateLastInsertedIdentityStatement()

Syntax

SQL_Statement as C = <SQL::Connection>.GenerateLastInsertedIdentityStatement( [ <TableInfo> as SQL::TableInfo ] )

Argument

Description

SQL_Statement

A SQL select statement.

<SQL::Connection>

A SQL::Connection object.

<TableInfo>

A SQL::TableInfo object.

Description

The SQL::Connection::GenerateLastInsertedIdentityStatement() method retrieves the last identity value generated for an insert on the currently open connection.

  1. This is current connection specific for most databases. For databases that use sequences to maintain identity (such as Oracle), the sequence may not be correct after the transaction has been completed.

  2. For databases that use sequences to generate identities <TableInfo> is a required parameter. It must include an identity column in its definition. That column must specify the sequence name to be used.

Supported By

Alpha Five Version 8 Enterprise Edition

Limitations

Desktop applications only.

See Also

SQL::Connection Object