Record "Blocking" ?

[ter055]

ok
the status column would be only be used for the thread-problem...

thanks for the "for update" option
I also was thinking in using it...

The question is now

if I use "select ... for update nowait"

but the web application uses only one connection-configuration
(one userName, one password) for all threads.
Is the DB stopping a second "select ... for update nowait"
even if it is being made using the same connection-configuration (but from a different thread).
Or is the DB 'thinking': ok is the same user, I allow it...???

Thanks
Ter