It would be very useful to be able to sort tables (grid and lookups) by something other than just columns ascending or descending.
For example to sort a column which will render NULLS at the top, but then the NON-NULL values following in descending order you'd need to specify something like:
ORDER BY CASE WHEN Col1 IS NULL THEN 1 ELSE 2 END asc, col1 desc.
You could, in dbFront perhaps, for total flexibility, allow the user to define the sort order as:
- By column asc or desc [as current]
- A column expression [example above] for any or all of the columns or,
- Just provide the entire ORDER BY clause