StrataFrame Forum

Any change in field data changes PK back to clustered

http://forum.strataframe.net/Topic10731.aspx

By Charles R Hankey - 8/6/2007

V 1.61.  PK is UID.  By default DDT created it clustered.  Change PK Index props to non-clustered in DDT

Later go back to this table in DDT  dirty buffer in any way ( on fields other than pk )

Save and close.  PK Index has changed back to clustered.  ( Can really bite you if you dont' remember to look for it )

Just something to look at before next release.  Smile 

By Charles R Hankey - 8/6/2007

Addendum : no change is necessary.  Just double click on any field to show field list on right then save and close and pk index reverts to clustered.
By StrataFrame Team - 8/7/2007

Yes, the primary key gets dropped and re-created every time the table is saved.  We'll be sure to work out a solution for GUID PKs.  Thanks for the heads up.
By Trent L. Taylor - 2/10/2008

A new table setting has been added which allows the automated primary key creation to be specified.  By default the primary keys will be created, however, ti disable the automatic primary key index creation, open the table properties and uncheck the option labeled, "Automated Primary Key Index Creation on Structure Saves.  This will be included in the 1.6.5 beta that I post later tonight (2/10/2008).  Thanks.