Hello,

I've a small data table with an identity field and an insert trigger saving the inserted values into a protocol table in another database.

In the datawindow, immediately after the insert the identity column doesn't contain the newly generated identity value of my table but the identity value of the protocol table. Another retrieve of the datawindow supplies the correct identity value.

My problem: I need the correct identity value immediately after the datawindow insert.

Here is what the trigger does:   insert into <protocol table> (fieldlist>) select <fieldlist> from ##inserted

Thanks in advance for any hint.

Regards, Peter