> You are absolutely right. I mean ; if I were using C/S architecture
> I should have a better way other than pessimistic locking. How do
> you solve this kind of problem in your applications ?

I dont. I have contemplated using DML Caching (link to tech info in
an earlier posting on this thread), however so far I have found it
unnecessary. The biggest of my applications is in the happy position
of conflicting updates being very rare - about thirty users accessing
the database, but these are spread across 6 different branches and so
is the work. So far I have not had any complaints. The only place
where conflicts are likely is in administrative function, and those
functions allow only a few users.

--
Geoff Worboys
Telesis Computing