You can view the issue detail at the following URL:
<http://scarab.werken.com/scarab/issues/id/TRQS131>
Type : Enhancement
Issue Id : TRQS131
Reported by: Eric Pugh
[EMAIL PROTECTED] - ([EMAIL PROTECTED])
Details:
Summary: Should use IDENT_CURRENT('table_name') for identity
Description: Currently identities are returned by doing a select @@identity, however
that has global scope. So, if torque does an insert into table Y, and then something
does another insert into table X, and then torque tries to get it's insert identity,
it will return table X's identity value! Something safer is to use the syntax:
select IDENT_CURRENT('table_name'), and thus would do:
IDENT_CURRENT('Y') and narrow the chances of getting the wrong identity, especially if
there was a transaction.
Status: New
Priority: Medium
Vote: Medium
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
