Hello Ben, Interesting idea. Tracing this on the server shows that there are zero records of this table in the selection but one is locked. And Unload Record doesn't change anything. Any other ideas? And the Transaction Level is zero. I do lock all tables at process startup on client and server, but then I set the active table to Read-Write for most tables. Testing not doing this and only unlocking the current table when opening a record didn't fix my problem. Thanks, Alan
On Wed, Dec 9, 2020 at 3:55 PM Ben Kershaw via 4D_Tech <[email protected]> wrote: > Alan Tilson wrote: > > >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). > > It could be that the process on the server (the one the trigger runs in) > still has it loaded in a locked state. To test this, create a method with > the “Execute on Server” attribute set, and call UNLOAD RECORD from that > method. Call the method from the client when you close the edit window; the > method will run in (what is known as) the “twin” process on the server and > free the record. > > When a new process starts, all tables are in a read/write state, and any > records loaded will be locked to other processes/users. I run a standard > init method for new processes that sets all tables to read only, and also > runs a method on the server that does the same thing for the “twin” process. > > Regards, > Ben Kershaw > ********************************************************************** > 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] > ********************************************************************** ********************************************************************** 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] **********************************************************************
