Send 4D_Tech mailing list submissions to
4d_tech@lists.4d.com
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.4d.com/mailman/listinfo/4d_tech
or, via email, send a message with subject or body 'help' to
4d_tech-requ...@lists.4d.com
You can reach the person managing the list at
4d_tech-ow...@lists.4d.com
When replying, please edit your Subject line so it is more specific
than "Re: Contents of 4D_Tech digest..."
Today's Topics:
1. Re: Record locking woes (Keisuke Miyako)
2. Re: Record locking woes (Ben Kershaw)
3. Re: Record locking woes (Douglas von Roeder)
4. Re: Record locking woes (Ben Kershaw)
5. Re: Record locking woes (nug)
6. Re: Record locking woes (Charles Miller)
----------------------------------------------------------------------
Message: 1
Date: Thu, 10 Dec 2020 20:07:37 +0000
From: Keisuke Miyako <keisuke.miy...@4d.com>
To: 4D iNug Technical <4d_tech@lists.4d.com>
Subject: Re: Record locking woes
Message-ID: <c94577e4-7dd4-451b-a08b-86c59e4a1...@4d.com>
Content-Type: text/plain; charset="utf-8"
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<mailto:4d_tech@lists.4d.com>>のメール:
there are zero records of this table in the selection but one is locked.
------------------------------
Message: 2
Date: Thu, 10 Dec 2020 16:06:09 -0500
From: Ben Kershaw <4d...@bonaire-diver.com>
To: 4d_tech@lists.4d.com
Subject: Re: Record locking woes
Message-ID: <2c5f8de7-c03e-4ffc-8610-b3c2a2227...@bonaire-diver.com>
Content-Type: text/plain; charset=utf-8
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.
Hmmm…
Regards,
Ben
------------------------------
Message: 3
Date: Thu, 10 Dec 2020 13:09:04 -0800
From: Douglas von Roeder <dvonroe...@gmail.com>
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Ben Kershaw <4d...@bonaire-diver.com>
Subject: Re: Record locking woes
Message-ID:
<capr+oi91ehebrpi5_cqgy17hyrnfehlaspockz4pfa8kfxb...@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
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 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.
Hmmm…
Regards,
Ben
**********************************************************************
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
**********************************************************************
------------------------------
Message: 4
Date: Thu, 10 Dec 2020 16:11:28 -0500
From: Ben Kershaw <4d...@bonaire-diver.com>
To: 4d_tech@lists.4d.com
Subject: Re: Record locking woes
Message-ID: <a4bc646a-79ca-4535-8a22-b96e86696...@bonaire-diver.com>
Content-Type: text/plain; charset=utf-8
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
------------------------------
Message: 5
Date: Thu, 10 Dec 2020 19:46:55 -0500
From: nug <4d_o...@pghrepository.org>
To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Ben Kershaw <4d...@bonaire-diver.com>
Subject: Re: Record locking woes
Message-ID: <43d69f9e-cae0-4c16-a12b-20cadf640...@pghrepository.org>
Content-Type: text/plain; charset=utf-8
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 modification of the child record due to
automatic relation loading the parent
Ex: a lineitem is being modified, and an automatic relation (possibly many
levels removed) pulled and loaded the invoice which is being locked because
there is a changed child record
Just guessing
Again - add record looking info commands to get a better idea
Chip
On Dec 10, 2020, at 4:11 PM, Ben Kershaw via 4D_Tech <4d_tech@lists.4d.com>
wrote:
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
**********************************************************************
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
**********************************************************************
------------------------------
Message: 6
Date: Thu, 10 Dec 2020 20:38:09 -0500
From: Charles Miller <miller.c...@gmail.com>
To: 4D iNug Technical <4d_tech@lists.4d.com>
Subject: Re: Record locking woes
Message-ID:
<cadksfq4pcba+etuz-sx2v42mdrgck+_pgkhnxasrmoue6fn...@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
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 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 modification of the child record due to
automatic relation loading the parent
Ex: a lineitem is being modified, and an automatic relation (possibly many
levels removed) pulled and loaded the invoice which is being locked because
there is a changed child record
Just guessing
Again - add record looking info commands to get a better idea
Chip
On Dec 10, 2020, at 4:11 PM, Ben Kershaw via 4D_Tech <
4d_tech@lists.4d.com> wrote:
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
**********************************************************************
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
**********************************************************************
