Sorting a List View Report

[JeremyM]

I have a list view report :

desc id
woood 3432
iron 3433
metal 3432

I my some command buttons to sit along side as up and down arrows. I want the highlighted row to move up or down in the lVW so that they can be reordered. I have a variable called sort_order. But it is not passed. I have the update feature working.

Does anyone know what code could be used to move the selected item inside the lst view?

 

[peekay]

If you wish to reorder items in a listview control in report mode you must use the columnheader click event and add code to sort the items or you can choose sorting from the control's properties. If there are no real sort orders you can set the items again by setting the first item as the item in the itemclick event

PK Odendaal
pko@mweb.co.za

 

[JeremyM]

OK Thanks. I did it. I just ran SQL to "add" the item 1 position up and one position back then also had SQL to "delete" the old one.

Thanks,
Jeremy