https://frontaccounting.com/punbb/viewtopic.php?id=10368 Sat, 16 Sep 2023 04:08:07 +0000 PunBB https://frontaccounting.com/punbb/viewtopic.php?pid=42566#p42566 This is a well known race condition. The corresponding INSERT statement should be modified to make the primary key as NULL so that it is generated at runtime and then last_insert_id() should be used to populate the dependant foreign keys.

]]> Sat, 16 Sep 2023 04:08:07 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=42566#p42566 https://frontaccounting.com/punbb/viewtopic.php?pid=42552#p42552 If I open a journal entry with reference number 30 and have not finished working on it, and my colleague opens another entry before I finish working on entry number 30, he will take the same reference number 30. When the entry is saved, whoever saves it first saves it without error, and whoever saves it last will receive an error. Is it possible? Every time a record is opened, it takes a different reference

]]> Fri, 08 Sep 2023 03:06:28 +0000 https://frontaccounting.com/punbb/viewtopic.php?pid=42552#p42552