For some reason, I'm stumbling trying to figure this one out, so I'm looking for suggestions.
We have a file of interest rates which we are currently indexing on:
BankCode+DTOS(ValueDate)
Our form class makes use of this primary tag to properly populate our 2 combo boxes for the 2 key fields for the user to choose the right record from. We have a user that wants us to change the intial display to be based on the most recent date instead of the first date for the corresponding bank code.
So, the question is: how do I create an index expression that produces an
ascending sort of the bank code and a
descending sort of the date? We can't change the form to use a view or SQL cursor because that would be too huge an overhaul for this one item. :)
TIA
Laterness,
Jon
Jon Rosenbaum
Devcon Drummer