Regina Phandu schrieb:

>
> Many thanks to Lucas and Martijn!!
>
> I removed the Suspend and the procedure works well.

But this way you're returning just the prodcode and qty for the last
record that was found in the FOR SELECT loop.

What's the sense of this?

And if you don't delete the entries in the t_transaction table and
execute the procedure again you'll diminish the values for qty within
tm_pos_product once again....

Luc.