Posted by helmut woess on 09/27/05 18:16

Am 27 Sep 2005 02:04:29 -0700 schrieb David Portas:

> Assuming you are using SQL Server 2000 then use SCOPE_IDENTITY() rather
> than @@IDENTITY. SCOPE_IDENTITY won't be affected by an insert in the
> trigger.

I think there was a litte misunderstanding, i don't use @@identity, i use
ident_current(). The problem is not in the trigger, it is in the ADO
component from Delphi. It looks like the component is reading @@identity
instead of scope_identity(), so it gets the wrong value.

bye,
Helmut

[Back to original message]