Hello everyone, I'm having a record locking problem where I cannot understand how the record is staying locked. There is no open transaction and no record stack (Push Record).
I simply open a record from a list view and close it. The table is still read-write but the record is unloaded. Load Record can load another record without releasing the locked record. I don't see anything in the trigger code that would keep the record locked and trigger issues discussed here seem to affect related tables, not the main table. Opening another record in the offending process does unlock the locked record, but users report that sometimes this does not work. They have to close the process. 4D v17.4 Client Server, Windows Server 2008 R2 server and client I'm thinking to try going to read-only in the list view to see if that works but I would love to hear some other ideas! Thanks, Alan Tilson On Fri, Aug 29, 2014 at 1:33 AM Justin Leavens <[email protected]> wrote: > Ben Kershaw-3 wrote > > Create a method that calls READ ONLY(*), and set the method to execute on > > the server. Call this method from your init process method (I’m assuming > > you have one). > > > > If the problem is a trigger loading a record in another table and leaving > > it locked, this will start all tables in READ ONLY mode, so when the > > record is loaded it will be in READ ONLY state. > > > > If you still have records getting locked, at least you’ll know it has > > nothing to do with triggers or something running in the servers ‘twin’ > > process. > > Thanks, Ben. Indeed I found the culprit was a related table being loaded in > a trigger and not being unloaded. This resulted in the record being > reported > locked by the process (yes, I use Chuck's locked record component) yet zero > records loaded on the client. And this of course worked differently in > client server than it did in single user. Thanks for the tip! > > > > -- > View this message in context: > http://4d.1045681.n5.nabble.com/Record-locking-woes-tp5732498p5732638.html > Sent from the 4D Tech mailing list archive at Nabble.com. > ********************************************************************** > See how easy it is to extend your 4D solutions to Web and mobile. New > opportunities await you with 4D v14! > > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** > ********************************************************************** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
