Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uunet!mcsun!ukc!tcdcs!swift.cs.tcd.ie!vax1.tcd.ie!mtynan
From: mtynan@vax1.tcd.ie
Newsgroups: comp.databases
Subject: Multi-user problems with Clipper & R&R
Message-ID: <1991Feb6.224717.7724@vax1.tcd.ie>
Date: 6 Feb 91 22:47:16 GMT
Organization: Trinity College Dublin
Lines: 25




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!