(UTC)
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Record Locking (Read 3711 times)
cbislander
Full Member
***
Offline



Posts: 103
Joined: Mar 22nd, 2018
Record Locking
Mar 11th, 2022 at 1:40pm
Print Post Print Post  
I have notice that some records are Locked in my inventory database, but the database itself is fine.

The records are Locked but no other user is currently accessing the database, let alone the record.

This will be a problem for Mass Updates that are done through the day and the day end.

Is there a way to search find all Locked records?

If not, how do I make sure the database is unlocked before doing the Mass Update?

I am familiar with the Unload and Sunlock commands.
  
LockedRecord.png ( 24 KB | 38 Downloads )
LockedRecord.png
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Record Locking
Reply #1 - Mar 11th, 2022 at 2:39pm
Print Post Print Post  
There is no search that can find all locked records.

If records are being locked and no-one has them open, the likely cause is an @XResultSetSearch() with no XResultSetClose(). This leaves the current record in that XResultSet open and locked to all other users. @XResultSetSubSet(), @XResultSetNew(), @XResultSetParent() and @XResultSetForm() should also all have a matching XResultSetClose() call.

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
cbislander
Full Member
***
Offline



Posts: 103
Joined: Mar 22nd, 2018
Re: Record Locking
Reply #2 - Mar 11th, 2022 at 7:31pm
Print Post Print Post  
Hi Ray,

I think I got it.
I had 2 XResults in one field: RSHandle and RSHandle1, but I only had the XResultSetClose for the first one.
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge