> Then I discovered a strange problem using pessimistic locking. When
> I lock a masterrecord with references to a detail table, i could not
> insert new records to the detail table.

The only reason I can imagine for this is if the master and detail
were using different transactions.

--
Geoff Worboys
Telesis Computing