>>Actually, I just re-read Fabio's suggestion
>>
Re: SPT, updatable cursor and last identity value Thread #
1458392 Message #
1459209>>
>>I don't think I've tried that, but it does indeed sounds like a solution and I should have tried this instead of keeping the original code.
>
>I don't get why he is getting scope identity if the tableupdate fails?
He is using it only when tableupdate succeeds. Re-read the suggestion, he is checking the tableupdate status:
if tableupdate(.f.) &&.f. so we're updating only one record.
If it's not broken, fix it until it is.
My Blog