Thanks all.
I received some mail that explained why "lock table ...share mode"
did not prevent row level locks being used. Its so queries, other
than "dirty read" level queries, do not see the inserted rows until
they are committed.
The manual does not cover this topic very well.
--
Paul Mahoney, X-Act Solutions Limited
smail: 20 Shipley Lane, Cooden, Bexhill-on-Sea, East Sussex, TN39 3SR
email: ptm@xact.demon.co.uk ... pmahoney@cix.compulink.co.uk
phone: +44 424 3 6368