>>>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.
If it's not broken, fix it until it is.
My Blog