Hey....I'm an old school programmer...programming with dbase IV 2.0 dosbased and on our system (which is on its way out - Oracle coming in). I need a little help.
I need to index a file on three fields (which I do all the time), but I need to index them in descending order. I've never fooled with MDX files, just dbf's and Ndx's........can someone give me a syntax line that will put this in descending order? Here is an example of what I did.....someone can add to it so it can be in descending order
Index on <nbr1>+<nbr2>+<nbr3> to <indexfile>
use <file> index <indexfile>
This will put it in ascending order.....how do I make it descending??