Any change in field data changes PK back to clustered


Author
Message
Charles R Hankey
Charles R Hankey
StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)
Group: Forum Members
Posts: 524, Visits: 30K
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 

Charles R Hankey
Charles R Hankey
StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)
Group: Forum Members
Posts: 524, Visits: 30K
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.
StrataFrame Team
S
StrataFrame Developer (6.2K reputation)StrataFrame Developer (6.2K reputation)StrataFrame Developer (6.2K reputation)StrataFrame Developer (6.2K reputation)StrataFrame Developer (6.2K reputation)StrataFrame Developer (6.2K reputation)StrataFrame Developer (6.2K reputation)StrataFrame Developer (6.2K reputation)StrataFrame Developer (6.2K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
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.
Trent Taylor
Trent Taylor
StrataFrame Developer (13K reputation)StrataFrame Developer (13K reputation)StrataFrame Developer (13K reputation)StrataFrame Developer (13K reputation)StrataFrame Developer (13K reputation)StrataFrame Developer (13K reputation)StrataFrame Developer (13K reputation)StrataFrame Developer (13K reputation)StrataFrame Developer (13K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
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.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search