One browse doesn't sort header

[seanh]

I have one browse where the headers don't cause a sort of that column.
All the others are fine, and I can't see any difference!!

Help!!!

[Bruce]

Is that column a field in the table, or an expression?

[seanh]

It's a field in the table.
It's actually a memory driver table filled by a stored procedure in init.
But all the browses are like that and this is the only one that doesn't sort

[Bruce]

if it's a field in the table it should sort ok. Perhaps turn on the debug options to send the filter and order to debugview, then inspect the order there when you sort by that column?

also I presume sorting on this column has not been set to "disabled" - something you can set on the Sort tab settings for that column...

cheers
Bruce

[seanh]

I'll try and look

Just to note, this is All columns not sorting, not just one particular one.

[Bruce]

oh - _all_ columns. ok, make sure the browse is page loaded not file-loaded.
And make sure sorting is set to Server-side, not "none".

cheers
Bruce

[seanh]

Sorting is set as server-side.
But it's set to file load.
In fact all the browses are set to file load, and all the others column sort fine.
I'll try page loaded and see if there is a difference.

[Vinnie]

Hi

Browse column needs to have a header for sort to work.
Browse column needs to be in the data table not in the local data table.

Cheers

Vinnie

[seanh]

@Vinnie
Not sure exactly what you mean by needs to have a header? There is a header unless I misunderstand.
The data in all cases in this app comes from an SQL stored procedure thats copied into a memory table.  All other browses work fine and sort by column exept this one, which seems to be identical to alll the others.

[kevin plummer]

Hi Sean,

try to set the browse to only show 10 records or whatever so you display the next last buttons etc. If they don't work look at the data for any strange characters or if you have any columns set to allow xhtml. Try to also use the browser debug tool to see if it returns any xml errors when loading the browse.

Cheers,

Kevin