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.