Technote Details :: Move up/down does not work for newly inserted records

I've created a NeXTensio List and Form, using order columns. The move up / down works for records that were already in the table, but for records added through the form, only the client-side ordering is performed. When I click the Save button, the order is lost.

• Products: NeXTensio List.

• Operating System: All.

• Server Models: All.

• Dreamweaver version: any.

This happens because the list and form do not use the same table column for the move up/down option. The form and list must use the same column, because when inserting a new record through the NeXTensio form, a trigger will auto - increment the order column, thus avoiding duplicate or incorrect values. Based on this column, the list orders the elements, and allows the move up and down actions. If a different numeric column is selected in the Create NeXTensio Form Wizard, it will be auto-incremented instead of the actual order column, thus resulting in an incorrect value for the order column.

In order to be able to use the move up / down options in the NeXTensio list, you must specify the same column both in the Create NeXTensio List Wizard, and the Create NeXTensio Form Wizard. If you accidentally selected another column in one of the wizards, edit their corresponding server behaviors from the server behaviors tab, and select the correct one.