records not locking?

[Richard Kreiss]

Windows fp 5.7.03

Test this scenario on a file named test.  1 record in the file.

Session one - from rclerk went to update the one field in the file.

Session two - from rclerk went to update record one - message "Record Is Being Updates - Access Denied"

Then ran the same tests with one session with dclerk (update) and the other rclerk.  Then reversed the sequence.

Then ran test with both sessions using dclerk.

In all cases the second try at update showed the same popup.


Richard Kreiss
GCC Consulting

Office: 410-653-2813





> -----Original Message-----
> From: filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com
> [mailto:filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com] On
> Behalf Of Kenneth Brody
> Sent: Wednesday, April 16, 2014 1:31 PM
> To: Del; filePro Mailing List
> Subject: Re: records not locking?
> 
> On 4/16/2014 12:39 PM, Del wrote:
> > After reading about this problem, I tried it here.
> > On a Windows 7, filePro 5.0.11 system, the system allowed me to get
> > into update mode on the same record at the same time from two different
> sessions.
> > I made a small change in the first session, saved it, verified the
> > change, then saved the same record from the second session with no
> > changes, and this wiped out the change from the first session.  There
> > were no lookups involved, just using dclerk update on the same record at
> the same time.
> > However, when I tried the same thing on my Unix system, an attempt to
> > update a record that was already being updated on another session gave
> > me the message, "Record Is Being Updated - Access Denied".
> > This difference between the Windows based system the the Unix based
> > one is very surprising (and disturbing!).
> > Am I doing something wrong, or is there an actual problem here?
> > Certainly don't want this happening at my client locations.
> 
> I've never heard of such a thing happening on anything other than the ancient
> non-network MS-DOS version of filePro.  There's no such thing as a non-
> network Windows version, and there hasn't been an MS-DOS version since
> long before 5.0 came out.
> 
> Are your two dclerk sessions on the same Windows box, or two different
> ones?
>   Are the filePro files stored locally, or a network drive?  If network, what is
> the host?
> 
> --
> Kenneth Brody
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list