This behavior help you on create a new value for the sort order field.
Use this behavior in your insert record page. This behavior is apply to a hidden field and when the page load read the max value of the sort order field in the table and insert the max+1 value in the hidden field. Now when you setup the Insert Record Behavior you must bind this hidden field to the sort order table field so the new created value will be insert in the new recordset.
The form field where save the new sort order value.
Normally is an hidden field
The connection for the update sql query. A valid connection for the database whith the table you want update the sort order.
The table you want change the sort order.
The table sort order field.
This field is used in update pages, don't setup in insert pages.
In the update pages you must choose, with the right button, the sort order field from the recordset you want update. When the extension detect a value in this field verify if the value is unique in the table and in the case the value is repeated create a new sort order. This behavior is required when for a case in the tabel you have 2 times the same sort order in 2 record that will cause an incorrect sort behavior.
Important: don't setup this field in the insert record, but only in the update record