Sort Records Ascending and Descending

[biztrac]

Greetings All,

I am looking for a modular script or custom function that I can use to sort records both ascending and descending. I'm NOT sorting records in a portal.

I know the field labels in the table view will do exactly what I want, but I can't use that view.

I need one that can do either text or numeric data. If that means two functions, that's cool too.

I know I can do this by creating scripts for each field and for each sort direction using a variable to track the sort direction, but I am looking for something with much less overhead. A custom function would probably make the most sense. Just can't find one or figure it out.

I've searched this and other forums and haven't found it. I tried to adapt something but I just couldn't wrap my brain around it.

Thanks in advance for your help.

George

[Ender]

A custom function won't help here.

One way or another you're going to have overhead. Either with multiple Sort[] steps or with a getfield() calc.

[Søren Dyhr]

I wouldn't reject carthesian selfjoin portals though:

http://www.filemakerpros.com/LessSort.zip

--sd