>>>I am pretty sure I used the following syntax before, in another program. And it worked there. Now I am using the following code to get the PK value of the newly inserted row:
>>>
>>>

>>>SQLEXEC( hCon,"select SCOPE_IDENTITY() AS nValue","cur_identity")
>>>nCompPk = cur_identity.nvalue
>>>

>>>
>>>But the value of nCompPk and cur_identity.nvalue is NULL.
>>>
>>>What am I missing?
>>
>>Check Re: Auto Refresh Key fields after insert with CA Thread #1100805 Message #1111814 You can not use SCOPE_IDENTITY as a separate SQLEXEC command.
>
>Thank you, Naomi. I will check out the message your referenced. Although I should mention that I don't use CA.

It doesn't really matter. Look at the bottom of the message in BeforeInsert.