Hi Martijn,

> > This query produces the expected result, which is the records in
> > descending time order:
> >
> > SELECT RXSTAMP FROM RXOLDREQUESTRECORDS ORDER BY RXSTAMP DESC
> >
> > this one doesn't, the records are in ascending order:
> >
> > SELECT RXSTAMP FROM RXOLDREQUESTRECORDS ORDER BY 1 DESC
> >
> > (RXSTAMP is a TIMESTAMP)
> >
> > Can anyone suggest why? A similar query I have contains a union so
> > using the first form is not possible...
>
> Can you reproduce this problem in the command line tool "isql"?

I just tried this with isql and IBExpert and it is fine with both of
them. The problem comes with my Delphi 7 / DBExpress application.


Martin