>>Hi everybody,
>>
>>We're using SPT and then a special program to make cursor updatable. I see this code to get the last inserted value
>>
>> mysqlexec("select @@identity as keyval",'csrKeyVal', program())
>>
>>which doesn't look entirely correct to me - who guarantees that by doing a separate query you'll get the value of the record you just inserted and not someone else in between?
>>
>>Is there a better way to get the latest value?
>>
>>Thanks in advance.
>
>Of course it is not correct. You cannot even guarantee it doing in the same query batch. There are other and reliable ways like:
>
>select scope_identitity()
>
>select ... from inserted
>
>output clause
>
>Cetin
I don't understand how can we use them for the cursor made updatable using technique similar to Vlad's blog. In other words, there is no INSERT command, the changes are done in the cursor, then we do TABLEUPDATE. Then we need to get the ID back. How can we do this?
If it's not broken, fix it until it is.
My Blog