Sorry its me again.

Reverse engineering creates the following SQL chunk:

CREATE INDEX "by_model_name" ON "Models"
("model_name" DESC COLLATE "ANSI")
DESCRIPTION 'Order by model name';

Looks like the DESC and COLLATE are the wrong way round so when I execute in an SQL window I get:

ElevateDB Error #700 An error was found in the statement at line 2 and column 20 (Expected ) but instead found COLLATE)

All operations done in 1.06

Peter

Peter,

<< Reverse engineering creates the following SQL chunk: >>

Thanks, I'll make sure that this is fixed for the next release.

--
Tim Young
Elevate Software
www.elevatesoft.com