|
|
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
Navigation:
[Reply to this message]
|