autonumber-system-wide(a,b)

Prev Next

Like the function autonumber(a,b). However, the number ranges defined by this function are valid system-wide, across profile boundaries.

Important note: This function is only safe on a system without load balancing. On load balancing systems, a stored procedure or similar must be used to achieve ACID (atomicity, consistency, isolation, durability) across the load balancing cluster. When this function is executed, a connection to the main database ("hub") is established and closed again. Please note that this can lead to large performance losses with very frequent function calls.

GUI

See section Constants (-> "Configuration") for system-wide number ranges.