[comp.databases] Multi-user problems with Clipper & R&R

mtynan@vax1.tcd.ie (02/07/91)

A problem.

My company has developed a Clipper application (summer '8) which has
a number of reports in R&R (version 3).

The application is mutli-user, and the problem is thus :-

When a record is locked in the .DBF, if another user is running one of
the R&R reports, R&R terminates the report after a short while, with the
a 'lookup failure' message on the .DBF being rlocked() by another user. The 
lookup failure wouldn't be on the rlocked() record either.

My question is this - does Clipper lock the index file too?, thus preventing
R&R from finding a relation?

Has anybody come up with a work around for this problem?, not allowing file
write access in R&R is out of the question due to the on-line nature of the
application.

Any help would be gladly apprieciated!