Re: Record locking woes

2020-12-10 Thread Charles Miller via 4D_Tech
I had thought you were using my locked record component. Doesn’t it turn who had it locked On Thu, Dec 10, 2020 at 7:47 PM nug via 4D_Tech <4d_tech@lists.4d.com> wrote: > Alan, > You need to add/use the commands for returning the lock record information. > His can help determine who/where is lock

Re: Record locking woes

2020-12-10 Thread nug via 4D_Tech
Alan, You need to add/use the commands for returning the lock record information. His can help determine who/where is locking the record. I am wondering if maybe the lock is indirect i.e. a parent record locked because a child is loaded read/write and, the parent record was dragged in to the modi

Re: Record locking woes

2020-12-10 Thread Ben Kershaw via 4D_Tech
Alan Tilson wrote: >Locked By does return the locking process, user, machine, and proc name. Is the server holding the lock, or is another client? If it’s on the server, is it in the twin process for the client, a twin process for another client, or another process on the server? Regards, Ben

Re: Record locking woes

2020-12-10 Thread Douglas von Roeder via 4D_Tech
Ben: "4/4 in D flat, naturally." :-) -- Douglas von Roeder 949-910-4084 On Thu, Dec 10, 2020 at 1:06 PM Ben Kershaw via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Douglas von Roeder wrote: > > >One of our 4D musicians needs to make a blues song out of this. > > I play bass & piano, but haven’t w

Re: Record locking woes

2020-12-10 Thread Ben Kershaw via 4D_Tech
Douglas von Roeder wrote: >One of our 4D musicians needs to make a blues song out of this. I play bass & piano, but haven’t written anything original. Maybe now’s the time: “Record locking woes” “My index dun left me” “My old code got no Class” “Everything seems OK” 4/4 in D flat, naturally.

Re: Record locking woes

2020-12-10 Thread Keisuke Miyako via 4D_Tech
If you CUT NAMED SELECTION when there is a loaded current record, the current selection will be reduced to 0 but the current record will remain loaded (and locked) outside the current selection. 2020/12/11 2:38、Alan Tilson via 4D_Tech <4d_tech@lists.4d.com>のメール: ther

Re: Record locking woes

2020-12-10 Thread Alan Tilson via 4D_Tech
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, bu

Re: Record locking woes

2020-12-10 Thread Alan Tilson via 4D_Tech
Hello John, I am generally relying on the standard built-in warning when opening a locked record that 4d does, but Locked By does return the locking process, user, machine, and proc name. And I am only seeing this so far on client-server. Thanks, Alan On Wed, Dec 9, 2020 at 9:25 AM John DeSoi wro