Sort order for Designer Tables (structure window)

building semantic layer
1

Hi All,

Does anyone know if it is possible to have Designer display the columns in
the same order as they are defined in
the database when you add a table to the structure window?

The default sort order is alpha.

Thanks in advance

Jeff Moore
Electronic Data Systems

Listserv Archives (BOB member since 2002-06-25)

2

An easier way to change the order of the fields from alphabetical to default
database order is to modify the *.sbo file (e.g. Ociv7.sbo for Oracle).

Change the ColSort parameter from 3 to 13.

Cheers,
Luis

Listserv Archives (BOB member since 2002-06-25)