Sort a memory table.

Hi all,

I use a memory table where I can sort the columns by clicking in the columnheader. I can fix the sort by "Store the sorts".
When I use tabledisplay(Table,X) the sort is disturbed and the original index sort is restored.

Does anyone know if this is normal behaviour and it is not possible the restore the tablesort or do I need a special parameter or function.

Best regards,

Aad

Hello Aad,

The TableSortedColumn() function returns the name of the current sorted column. The help states that it returns a list of sorted columns but that has never happened for me.

You could save the sorted column name to a string prior to using TableDisplay and then use TableSort with the saved string value to restore the correct sort order.

Regards
Al

Hi Aad

My suggestion is to apply the sort to the data source and then do a TableDisplay(), this will provide you the always the desired qequencing.

Cheers

Peter

I agree with Peter
Do the sorting in the Query
It is the most optimal option

[infosonline.net]

Thanks guys,

I will try out your several options.

Best regards,

Aad