Sort Order With New Records

[htrimboli]

I read here in the forum that the new release will have a "default sort order" feature, which is great. I'm not sure if that will solve my problem or not.

When I add a new record, it always shows up at the end of the list, both in list view and in the "jump" box. When I go into MyPHPadmin and perform an "ALTER TABLE `table_name` ORDER BY `column_name`" command, this corrects the list in Dataface as well.

Is there a place I can put this command, maybe using an "on save" type trigger? I couldn't quite figure that out from the tutorials.

[shannah]

Hi,

The default sort order feature of dataface pertains only to relationships - allowing you to have a default sort order for related records. http://framework.weblite.ca/documentation/how-to/how-to-assign-order-to-related-records

The solution that you suggest would work fine for setting the default order on the table itself. Just implement the afterInsert() trigger and performm your ALTER TABLE statement to adjust the order.

Best regards

Steve