>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.