StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



Any change in field data changes PK back to...Expand / Collapse
Author
Message
Posted 08/06/2007 1:41:02 PM


StrataFrame Novice

StrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame Novice

Group: StrataFrame Users
Last Login: Today @ 6:59:17 PM
Posts: 122, Visits: 924
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.   

Post #10731
Posted 08/06/2007 1:45:17 PM


StrataFrame Novice

StrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame NoviceStrataFrame Novice

Group: StrataFrame Users
Last Login: Today @ 6:59:17 PM
Posts: 122, Visits: 924
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.
Post #10733
Posted 08/07/2007 9:11:28 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 9:09:33 AM
Posts: 2,661, Visits: 1,876
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.


www.bungie.net
Post #10743
Posted 02/10/2008 4:42:03 PM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 2:43:51 PM
Posts: 4,241, Visits: 4,285
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.
Post #14257
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ben Chase, Trent L. Taylor, Steve L. Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 8:12pm

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.062. 10 queries. Compression Enabled.
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.