﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>StrataFrame Forum / StrataFrame Database Deployment Toolkit / Issues  / Any change in field data changes PK back to clustered / Latest Posts</title><generator>InstantForum.NET v4.1.4</generator><description>StrataFrame Forum</description><link>http://forum.strataframe.net/</link><webMaster>forum@strataframe.net</webMaster><lastBuildDate>Mon, 13 Oct 2008 16:01:41 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: Any change in field data changes PK back to clustered</title><link>http://forum.strataframe.net/Topic10731-13-1.aspx</link><description>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.</description><pubDate>Sun, 10 Feb 2008 16:42:03 GMT</pubDate><dc:creator>Trent L. Taylor</dc:creator></item><item><title>RE: Any change in field data changes PK back to clustered</title><link>http://forum.strataframe.net/Topic10731-13-1.aspx</link><description>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.</description><pubDate>Tue, 07 Aug 2007 09:11:28 GMT</pubDate><dc:creator>Ben Chase</dc:creator></item><item><title>RE: Any change in field data changes PK back to clustered</title><link>http://forum.strataframe.net/Topic10731-13-1.aspx</link><description>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.</description><pubDate>Mon, 06 Aug 2007 13:45:17 GMT</pubDate><dc:creator>Charles R Hankey</dc:creator></item><item><title>Any change in field data changes PK back to clustered</title><link>http://forum.strataframe.net/Topic10731-13-1.aspx</link><description>V 1.61.  PK is UID.  By default DDT created it clustered.  Change PK Index props to non-clustered in DDT&lt;P&gt;Later go back to this table in DDT  dirty buffer in any way ( on fields other than pk )&lt;/P&gt;&lt;P&gt;Save and close.  PK Index has changed back to clustered.  ( Can really bite you if you dont' remember to look for it ) &lt;/P&gt;&lt;P&gt;Just something to look at before next release.  :) </description><pubDate>Mon, 06 Aug 2007 13:41:02 GMT</pubDate><dc:creator>Charles R Hankey</dc:creator></item></channel></rss>