Hello Martijn,

>You could use a client side sorting method, eg via a TClientDataset.

>Alternatively, use a selectable stored procedure that returns the set of
>records and sort ASC when selecting from the stored procedure.

>Or use a Derived Table:

>select *
>from (select first 5 skip 10 ... order by id desc)
>order by id asc

>With regards,

>Martijn Tonies
>Upscene Productions
> <http://www.upscene.com> http://www.upscene.com

Many Thanks





[Non-text portions of this message have been removed]