TableSort, there's a way to remove a Sort in a table?

[IoSonoPiero]

Hello,
I've read on some posts that a TableSort is forever (like diamonds).
There's a way to remove it, so the data can be displayed according to the order of the file?


To solve this on a data with has been sorted with TableSort

• I've used SaveCSV to dump data
• then I've used Dispose method on table
• then I've used AddTable to recreate it
• then I've used LoadCSV to repopulate it

It's too stupid or can be a way to do this?

Thanks,
ghale

 

[specci48]

Hello ghale,

sorry but you have to clear the table and to load the file into the table again to get the "original" order of the rows...



specci48

 

[IoSonoPiero]

So the way I've used (see #1) is valid?

 

[Erel]

You can use:

table1.TableSort("")

It will remove the sort.

 

[IoSonoPiero]

I've tried this, but without success!!

 

[Erel]

The following code seems to work just fine:

Sub App_Start
    Form1.Show
    table1.AddCol(cNumber, "c1", 100)
    table1.LoadCSV("1,csv", ",", True, False)
    Msgbox("before sort")
    table1.TableSort("c1")
    Msgbox("after sort")
    table1.TableSort("")
    Msgbox("sort cleared")
End Sub

 

[IoSonoPiero]

I'll assure you that yersterday evening THIS CODE doesn't work on my mobile!!
Now it works.

So, I think that in my code there was something other that don't let me "unsort" the table contents.
So I've used the #1 post solution.

:sign0161: