Hi Terry

You need to create a List View from the Code table SmartObject. On the View's initialize rule there will be a statement to execute the view's list method. When you configure this rule you have the option to set the order in the Sort tab. If you select the "Sequence No" column in this tab your data will be sorted by that field.

Have a look at SmartForms Help for info on how to create List Views.

I think you will find it very hard to try and re-sequence the data using smartforms rules. What I would suggest is creating a stored procedure on your SQL server (if you have permission) that does the re-sequencing for you, and then expose this as a smartobject method. This procedure would accept the sequenceNo that you are moving and the direction and then peform the logic to re-sequence. You can then allow the user to select a row in the list and click the up or down button (toolbar buttons) to move the row. You will need to run the list refresh action after each move. 

If you need help on exposing a stored procedure as a smartobject method let me know.

Thanks.  You're idea of using a stored procedure sounds like a good idea.  I will try that.

I

Is there a way to keep the row that was moved up or down selected?

Example, I click on a row.  Then click on the button to move it up in the list.  My smartobject updates the database and then I redisplay the list with my row moved up.  But my row is no longer selected.  So before I can move it up another spot, I have to click the row again.  Is there a way to leave it selected?

Hi Terry

I am not aware of a way to keep the row selected after you refreshed the list.