> 2. Something else that I haven't proven is that it actually can have
> indexes that have are mixed order.
> E.G. PK ASC, Date DESC.:
> Firebird syntax:
> CREATE UNIQUE DESCENDING INDEX IDH_DATE_INSP_DESC ON INSPDHST (PART_NO,
> INSP_DATE, INSP_TIME);
> Standard syntax:
> CREATE UNIQUE INDEX IDH_DATE_INSP_DESC ON admin.INSPDHST ( PART_NO,
> INSP_DATE DESC, INSP_TIME DESC);
> After creation of the index, whether by script or in IBExpert, all indices
> show ascending, except the ones with descending elements have an odd
> negative number associated with them. Generally speaking it is dates and
> times that require descending components. We both know that there are

ways

> around this problem from our DAT days. But you also know, it is ugly, and
> not cool for non-Clarion reporting tools.

Firebird doesn't have mixed ordered indices.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com