Web forum is in read-only mode. Login as active registered customer for write access
  Forum Search   New Posts New Posts

Desc Index issue

 Post Reply Post Reply
Author
Blanchard Ed View Drop Down
Member
Member
Avatar

Joined: 05 May 2013
Posts: 47
Post Options Post Options   Quote Blanchard Ed Quote  Post ReplyReply Direct Link To This Post Topic: Desc Index issue
    Posted: 29 Apr 2017 at 10:21pm
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
Back to Top
Wagner R. Landgraf View Drop Down
TMS Support
TMS Support
Avatar

Joined: 18 May 2010
Posts: 2432
Post Options Post Options   Quote Wagner R. Landgraf Quote  Post ReplyReply Direct Link To This Post Posted: 02 May 2017 at 3:04pm
We have just released 2.8.1 version with a fix for that issue.
Back to Top
Blanchard Ed View Drop Down
Member
Member
Avatar

Joined: 05 May 2013
Posts: 47
Post Options Post Options   Quote Blanchard Ed Quote  Post ReplyReply Direct Link To This Post Posted: 03 May 2017 at 7:09am
Updated and verified - thanks Wagner!

EdB
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down