records not locking?

scooter6 at gmail.com scooter6 at gmail.com
Wed Apr 16 08:08:26 PDT 2014


the program does browse lookups to the actual file with dummy fields,
etc.....but this 'used' to work as designed but for some reason it doesn't
now
if I open two sessions now I can pull the record up in both sessions??


On Wed, Apr 16, 2014 at 11:06 AM, Richard Kreiss
<rkreiss at gccconsulting.net>wrote:

> Top post:
>
> Are you acing the record from a browse lookup and then updating the record?
>
> Is the update being done by a popup update to the lookup file or are you
> updating the record using a screen with dummy fields and then posting to
> the actual record?
>
>
> 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 scooter6 at gmail.com
> > Sent: Wednesday, April 16, 2014 10:46 AM
> > To: ken_wakeman at me.com
> > Cc: filepro-list at lists.celestial.com; Del
> > Subject: Re: records not locking?
> >
> > No that variable isn't set......
> >
> >
> > On Wed, Apr 16, 2014 at 10:32 AM, <ken_wakeman at me.com> wrote:
> >
> > > Could the environment variable PFREADONLY have been set? On a. Profile
> > > by chance.
> > >
> > > Sent from my BlackBerry 10 smartphone on the Bell network.
> > >   Original Message
> > > From: scooter6 at gmail.com
> > > Sent: Wednesday, April 16, 2014 10:26 AM
> > > To: Del
> > > Cc: filepro-list at lists.celestial.com
> > > Subject: Re: records not locking?
> > >
> > > Well this uses rclerk and we've never in the past (to my knowledge)
> > > been able to access the same record in this rclerk program....
> > > If I have the record 'directly' in update mode, and try to post a
> > > payment to it, then I get that message 'Record is being updated -
> access
> > denied'
> > > But I'm pretty shocked to see suddenly in this program two people can
> > > have the same record up at the same time and can make changes to it ,
> > > etc....but I do notice that if I'm the 2nd person to access it, and I
> > > make changes to it, it doesn't actually update the record? But if
> > > you're the first person to have it pulled up, those changes will take
> effect.....
> > > Very strange....I have double checked that all my lookups to this main
> > > customer file are 'protected' - I thought by doing that, you avoided
> > > this type scenario?
> > > Am I wrong on that?
> > >
> > >
> > >
> > > On Wed, Apr 16, 2014 at 10:14 AM, Del <neroni3000 at comcast.net>
> > wrote:
> > >
> > > > Don't know anything about CentOS.
> > > > However, I have been dealing with filePro for many years, and always
> > > > understood two people could not update the same record at the same
> > > > time (using dclerk or rclerk).
> > > > After reading your post, I tried it here on a Windows 7 based
> > > > system, and was a little flabbergasted to find that the system
> > > > allowed me to get into update mode on the same record from two
> > different sessions.
> > > > However, when I tried it 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!).
> > > >
> > > > Del Neroni
> > > >
> > > > -----Original Message----- From: scooter6 at gmail.com
> > > > Sent: Wednesday, April 16, 2014 8:04 AM
> > > > To: filepro-list at lists.celestial.com
> > > > Subject: records not locking?
> > > >
> > > >
> > > > We've had this filepro sytem for years -- CentOS 5.10 and filePro
> > > 5.6.10R4
> > > >
> > > > We have an app written years ago that is basically a front end
> > > > lookup to
> > > a
> > > > main customer file
> > > > It used to be if someone has a record pulled up from this main file,
> > > > and someone else attempted to access it, you would see at the bottom
> > > something
> > > > stating watiing for record to be unlocked or something like that,
> > > > don't remember the exact verbiage
> > > >
> > > > Some of you might remember I recently had to replace the CentOS RAID
> > > > and left the filePro RAID in tact when we had a root kit
> > > > virus.....so I
> > > simply
> > > > swapped the 2 OS drives and configured what I needed to user wise,
> > > > etc.....by taking the /etc/passwd files, etc from the old OS and on
> > > > to
> > > the
> > > > new OS drives....
> > > > Everything has worked out with no problems.....I only mention this
> > > because
> > > > this is the only thing that's changed on this system...
> > > >
> > > > Yesterday, one of my operations people informed me that two people
> > > > could have the same record pulled up at one time and update it 'at
> will'??
> > > > Now the program used to access the main customer file is just a
> > > > filePro file that does a lot of lookups to display the data from the
> > > > main
> > > customer
> > > > file - and I checked input processing and made sure all the lookups
> > > > are 'protected'
> > > >
> > > > Any idea what would cause them no longer seeing the 'waiting for
> > > > record
> > > to
> > > > be unlocked' message as before? Very strange.....this has never been
> > > > the case in the 15 yrs we've had this program built, etc....
> > > >
> > > > Thanks for any insight....pretty confused on this
> > > >
> > > > Scott
> > > > PDM
> > > > -------------- next part -------------- An HTML attachment was
> > > > scrubbed...
> > > > URL: http://mailman.celestial.com/pipermail/filepro-list/
> > > > attachments/20140416/ad21e007/attachment.html
> > > > _______________________________________________
> > > > Filepro-list mailing list
> > > > Filepro-list at lists.celestial.com
> > > > Subscribe/Unsubscribe/Subscription Changes
> > > > http://mailman.celestial.com/mailman/listinfo/filepro-list
> > > >
> > > >
> > > -------------- next part -------------- An HTML attachment was
> > > scrubbed...
> > > URL:
> > > http://mailman.celestial.com/pipermail/filepro-list/attachments/201404
> > > 16/7a18723f/attachment.html
> > > _______________________________________________
> > > Filepro-list mailing list
> > > Filepro-list at lists.celestial.com
> > > Subscribe/Unsubscribe/Subscription Changes
> > > http://mailman.celestial.com/mailman/listinfo/filepro-list
> > >
> > -------------- next part --------------
> > An HTML attachment was scrubbed...
> > URL: http://mailman.celestial.com/pipermail/filepro-
> > list/attachments/20140416/68dca1a0/attachment.html
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> > Subscribe/Unsubscribe/Subscription Changes
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20140416/a47b83fa/attachment.html 


More information about the Filepro-list mailing list