Desc Index issue

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

We have just released 2.8.1 version with a fix for that issue.

Updated and verified - thanks Wagner!

EdB