Data Modeler v2.8.0.1, MSSQL 2008
When creating a compound index, the sort order is not correct in the generated script.
Indexes Tab:
Index fields(name) Order
pricing_set_code Asc
op_amount Desc
opcode Asc
specific_rule Asc
"Generate Code" results in:
CREATE TABLE [dtr_freight_logic] (
[pricing_set_code] VARCHAR(15) NOT NULL,
[specific_rule] VARCHAR(15) NOT NULL,
[use_freight_factor] VARCHAR(1) NULL DEFAULT 'N',
[opcode] VARCHAR(2) NOT NULL DEFAULT 'GT',
[op_amount] INTEGER NOT NULL,
[result_factor] NUMERIC(18,4) NULL DEFAULT 0.0,
[create_date] DATETIME NULL DEFAULT GetDate(),
[date_stamp] DATETIME NULL,
[user_stamp] VARCHAR(50) NULL,
CONSTRAINT [dtr_freight_logic_pk] PRIMARY KEY ([pricing_set_code],[op_amount],[opcode],[specific_rule])
)
Which ends up with all fields being "ASC" in MSSQL.
EdB