S16350: Implemented update for new inserted recordId. Added

formSubmitLogId as reference in sql.log. Added new formSubmitLogMode = modify, it prevents writing formSubmitLogs for tables Dirty and FormSubmitLog. refs #16350

Documentation/Store.rst

@@ -286,11 +286,9 @@ QFQ values
 +-------------------+-------------+--------------------------------------------------------------------------------------------------------------------------------------------+
 | Name              | Scope       | Explanation                                                                                                                                |
 +===================+=============+============================================================================================================================================+
-| random            | Always      | Random string with length of 32 alphanum chars (lower & upper case). This variable is always filled. Each access gives a new value.        |
-|                   |             | Uniqueness is added via PHP function *uniqid()* which just prepends 13 chars at the beginning of the random string. *uniqid()* is only a   |
-|                   |             | very precise timestamp, therefore these first 13 chars should *not* be taken as random! They should make uniqness more likely.             |
+| random            | Always      | Random string with length of 32 alphanum chars (lower & upper case). See :ref:`RANDOM`.                                                    |
 +-------------------+-------------+--------------------------------------------------------------------------------------------------------------------------------------------+
-| slaveId           | FE *any*    | see :ref:`slave-id`                                                                                                                        |
+| slaveId           | FE *any*    | See :ref:`slave-id`                                                                                                                        |
 +-------------------+-------------+--------------------------------------------------------------------------------------------------------------------------------------------+
 | allRequiredGiven  | Form        | Form save - Set during check of all required FE. If every *required* FE is given: *1*. Else: *0*. If there is no required FE: *1*.         |
 |                   |             | Even with ``formModeGlobal = requiredOff | requiredOffButMark`` the variable will be set.                                                  |
@@ -310,6 +308,25 @@ QFQ values
 | mimeType          | FE *upload* | Mime type of the uploaded file.                                                                                                            |
 +-------------------+-------------+--------------------------------------------------------------------------------------------------------------------------------------------+
 
+.. _RANDOM:
+
+{{random:V}}
+^^^^^^^^^^^^
+
+* The variable *{{random:V}}* is always filled.
+* Hint: QFQ variables will be replaced **before** a SQL statement is fired.
+
+  * Each access gives a new value.
+  * Execution of a SQL statement is **one** access - therefore ``SELECT '{{random:V}}' FROM Person`` will give the same
+    random value for all *Person*.
+  * Several ``SELECT ...{{random:V}}...`` will give several different random values.                                                                   |
+
+* Uniqueness is added via PHP function *uniqid()*
+
+  * This just prepends 13 chars at the beginning of the random string.
+  * *uniqid()* is only a very precise timestamp - timestamp means it becomes bigger and bigger and the first characters stays the same.
+  * These first 13 chars should *not* be taken as random! They will make *uniqness* for *{{random:V}}* more likely.
+
 Custom values (via fillStoreVar)
 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^