>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