DDT Preserve/Update Field Order?

Author Message
 Posted 2/25/2014 4:04:30 AM
StrataFrame Novice

StrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame Novice

Group: StrataFrame Users
Last Login: 12/8/2014 4:29:38 AM
Posts: 80, Visits: 239
Hello,

After creating a new table with the DDT, I realized that the field order is not as expected, which is causing problems downstream in an application.

I went into the DDT and reordered the fields, but that doesn't seem to do anything when I deploy to the server. Also, if I create a new database (i.e. deploy to server), the field order is just as it was when the original table was added to the database.


UPDATE: I must have been seeing things regarding creating a new database, the field order is correct. However, if I deploy the updated field order to an existing database, the field order does not change.

Can anyone confirm?

Bill


Tags:

Edited: 2/25/2014 4:13:33 AM by William Fields
Post #32464
Add to Twitter Add to Facebook
 Posted 2/25/2014 6:00:08 AM
StrataFrame VIP

StrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIP

Group: StrataFrame Users
Last Login: 4/9/2021 12:42:36 PM
Posts: 2,436, Visits: 24,184
Hi Bill,

William Fields (2/25/2014)
Hello,
After creating a new table with the DDT, I realized that the field order is not as expected, which is causing problems downstream in an application.
Can anyone confirm?


Yes, that is the behavior of the current DDT version.  I believe it is a limitation of MS-SQL because I also use xCase for data modeling in some projects and they have an option to update a table by using the "Copy" command which will basically do the following:
  1. Create a new table with a temporary name
  2. Copy data from original table
  3. Delete original table
  4. Rename temporary table with original table name
If you need your field names in the order you are designing them, then you may have to manually do the above to get them updated.  I know it is a huge inconvenience, but hopefully new version of DDT for SF2.0 would take care of this issue.




Edhy Rijo
(Using VB.Net 2019/SQL Server 2017)
Post #32465
Add to Twitter Add to Facebook


Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.