Create ASC and DESC INDEX in in one index

247 views Asked by At

I want to create an index (in Delphi/Interbase) which contained a ASC and a DESC order.

Example:

CREATE INDEX AMUT_DAT ON ARTIKMUT(DATUM,ARTIKEL,KODE);

This create DATUM and ARTIKEL ascending.

When I create it as follow:

CREATE DESCENDING INDEX AMUT_DAT ON ARTIKMUT(DATUM,ARTIKEL,KODE);

then the field DATUM is ASCENDING, but also the ARTIKEL. I want DATUM descending and ARTIKEL ascending.

I tried:

CREATE INDEX AMUT_DAT ON ARTIKMUT([DATUM] DESC,[ARTIKEL] ASC,[KODE] ASC);

But that does not work.

How can I create such an index in Interbase?

0

There are 0 answers