Re: Descending Indexes

From: Greg Stark <greg-spare-1_at_mit.edu>
Date: Mon, 07 Feb 2000 05:49:28 GMT
Message-ID: <87n1pdy332.fsf@HSE-Montreal-ppp33976.qc.sympatico.ca>

Ritu <ritub_at_teri.res.in> writes:

> I have struggled so much but couldn't find a way to create desceding
> indexes using Oracle8 and Delphi4. My problem is that I want to display
> dates in descending order and also at the same time give the facility to
> update them so cannot use queries and views don't allow order by clause.
>
> Can anybody tell help me in solving the problem

Oracle doesn't do descending indexes but it can traverse an index in either order anyways to satisfy the query. Surely Delphi must give you some widget to control the ORDER BY part of the query. It seems to me it would be pretty useless to have a high level abstraction that didn't even encapsulate such a trivial sql concept as the order of the result set.

--
greg Received on Sun Feb 06 2000 - 23:49:28 CST