One of our 4D musicians needs to make a blues song out of this. -- Douglas von Roeder 949-910-4084
On Wed, Dec 9, 2020 at 12:55 PM Ben Kershaw via 4D_Tech < 4d_tech@lists.4d.com> 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:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ********************************************************************** 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:4d_tech-unsubscr...@lists.4d.com **********************************************************************