Thanks.
Il 30/07/2024 16:38, Randy Jaynes ha scritto:
First, as I know others have encouraged you, this list list is
effectively dead.
You should go to https://discuss.4d.com/ and use the online forum
there and forget this email address even exists. ;-)
It’s much better anyhow as you can post pictures and code more easily
than this simple mailing list ever allowed.
As to your question, the best way I can think is to use a 3rd process
(or maybe a CALL WORKER process) whose sole function is to return
sequence numbers outside of transactions.
SUSPEND TRANSACTION/RESUME TRANSACTION /may/ work for giving you a
sequence number outside of the transaction, but I’ve only done this
for related tables in code where I’m doing the full CRUD on the
related record and want to be sure it’s outside the current transaction.
The separate process for grabbing sequence numbers is the cleanest way
I can think of.
HTH,
Randy
------------------------------------------------------------------------
Randy Jaynes
DocketManager & PrintPoint Development and Support
For all PrintPoint support inquiries, please email
[email protected] or call 845-687-3741.
On 30 Jul 2024, at 5:03, stardata.info via 4D_Tech wrote:
I use the command " Find in field " for obtain a unique id during
a record creation during TRANSACTION .
I have two process that use this command into transaction.
Process1 obtain a unique id and is in trasaction, the id is 1
Process2 request an id with " Find in field " and have the same id
number, and in SAVE RECORD have an error of duplicate key.
How i can do to solve this case?
Thanks
**********************************************************************
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com <https://discuss.4D.com>
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
<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]
**********************************************************************
