Sorting a Browse by calculated field

[ianburgess]

I have a web browse which has a calculated field, using a local variable. The code to set the local variable is embedded Inside Browse Loop>1.Validate Record.

All works fine and the browse correctly displayes the local variable, EXCEPT that if one tries to sort by the contents of the local variable column by clicking the column heading, no records are displayed.

Can anyone suggest how to resolve this?

Many thanks.

[Bruce]

Hi Ian,

you can't sort by a calculated field - at least not directly.
The sort header translates into a prop:order statement for the View.
It's likely you would need to either hand-craft the prop:order (using the raw database fields) or turn off sorting on that column.

Cheers
Bruce