The system didn’t see the changes.

Comments

• James B Redgate › Posts: 1,124 Silver 4

  October 21, 2013 7:56AM

  I'm afraid I'm not really sure what the problem is here. Do you get an error message? Please can you send over a table definition and insert statement so we can replicate the problem?
  It might well be a bug with extended character-sets but I've not heard of it happening before so I'd like to see if I can reproduce the problem.

  Systems Software Engineer

  Redgate Software

  0 · Share on Twitter
• fadeev_av Posts: 6

  November 5, 2013 8:39AM

  Create table sample:

  CREATE TABLE MX_Developer.dbo.MX_WF_ObjectStructure(
  	ID_WF_Object INT NOT NULL,
  	ID_Object_Type INT NULL,
  	Parent_ID INT NULL,
  	NameRU VARCHAR(100) NOT NULL,
  	NameEN VARCHAR(100) NOT NULL,
  	Table_Name VARCHAR(128) NULL,
  	PK_Field VARCHAR(128) NULL,
  	ID_WF_UsingObject INT NULL,
  	Edit_Field VARCHAR(128) NULL,
  	Field_Type VARCHAR(128) NULL,
  	FK_Field VARCHAR(128) NULL,
  	WhereClause TEXT NULL,
  	Field_List TEXT NULL,
  	Value_List TEXT NULL,
  	Get_Method VARCHAR(500) NULL,
  	Set_Method VARCHAR(500) NULL,
  	ID_Journal INT NULL,
  	JournalPK VARCHAR(128) NULL,
  	JournalField VARCHAR(128) NULL,
  	ID_LogicType INT NULL,
  	Default_Value TEXT NULL,
  	Edit_Mask VARCHAR(150) NULL,
  	Visible_Condition TEXT NULL,
  	Enabled_Condition TEXT NULL,
  	Required_Condition TEXT NULL,
  	Dictionary_Condition TEXT NULL,
  	Constraint_Condition TEXT NULL,
  	Constraint_Message TEXT NULL,
  	ID_Sheet INT NULL,
  	IsPublished BIT NULL,
  	OrderNum FLOAT NULL,
  	Display_Name VARCHAR(150) NULL,
  	Display_Rows INT NULL CONSTRAINT DF_MX_WF_ObjectStructure_Display_Rows DEFAULT (1),
  	CreateDate DATETIME NOT NULL CONSTRAINT DF__MX_WF_Obj__Creat__1E56154F DEFAULT (getdate()),
  	ID_User INT NOT NULL,
  	UpdateDate DATETIME NULL,
  	Note TEXT NULL,
  	Filter_Condition TEXT NULL,
  	Use_In_Templates BIT NULL,
  	Editing_Condition TEXT NULL,
  	Filter_Func VARCHAR(500) NULL,
  	ID_Form INT NULL,
  	FormScript VARCHAR(MAX) NULL,
  	ID_WF_ImportObject INT NULL,
  	Import_Method VARCHAR(500) NULL,
  	ShowInFilter BIT NULL,
  	Colored BIT NULL,
  	DisplayButton BIT NULL,
  	ClearIfNotVisible BIT NULL,
  	UseInGroupUpdate BIT NULL,
  	Display_Name_ENU VARCHAR(150) NULL,
  	ColumnNumber INT NULL,
  	CONSTRAINT PK__MX_WF_ObjectStru__1F4A3988 PRIMARY KEY (ID_WF_Object)
  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  GO
  

  
  Insert stateent:
  
  [code]
  INSERT INTO [dbo].[MX_WF_ObjectStructure] ([ID_WF_Object], [ID_Object_Type], [Parent_ID], [NameRU], [NameEN], [Table_Name], [PK_Field], [ID_WF_UsingObject], [Edit_Field], [Field_Type], [FK_Field], [WhereClause], [Field_List], [Value_List], [Get_Method], [Set_Method], [ID_Journal], [JournalPK], [JournalField], [ID_LogicType], [Default_Value], [Edit_Mask], [Visible_Condition], [Enabled_Condition], [Required_Condition], [Dictionary_Condition], [Constraint_Condition], [Constraint_Message], [ID_Sheet], [IsPublished], [OrderNum], [Display_Name], [Display_Rows], [CreateDate], [ID_User], [UpdateDate], [Note], [Filter_Condition], [Use_In_Templates], [Editing_Condition], [Filter_Func], [ID_Form], [FormScript], [ID_WF_ImportObject], [Import_Method], [ShowInFilter], [Colored], [DisplayButton], [ClearIfNotVisible], [UseInGroupUpdate], [Display_Name_ENU], [ColumnNumber]) VALUES (20, 3003, 15, N'ПродукÑ‚', N'Product', N'TD_Client_Products', N'ID_Client_Product', NULL, N'ID_Product', N'int', NULL, NULL, NULL, NULL, NULL, NULL, 101075, N'ID ПродукÑ‚а', N'ПродукÑ‚', 4005, NULL, NULL, N'[ТипПродукÑ‚а] <> ''ПлаÑ

  0 · Share on Twitter
• James B Redgate › Posts: 1,124 Silver 4

  November 5, 2013 9:37AM

  Thanks
  
  I created the table, and then inserted the data. I was able to add this into SQL Source Control without any problem though.
  
  Do you have trouble when committing? Or do you have problems with existing files .sql from somewhere else?

  Systems Software Engineer

  Redgate Software

  0 · Share on Twitter
• fadeev_av Posts: 6

  November 5, 2013 11:21AM

  I have no problems with the first commit. But after the first fix and re-update changes the problem occurs. The system offers me again to fix all of the changes. A list of already fixed hostname is empty ...

  0 · Share on Twitter
• fadeev_av Posts: 6

  November 6, 2013 4:28AM

  Also, post the screenshots
  This is a working copy and the recorded data in the table:
  
  
  This is the result of updating the state:
  

  0 · Share on Twitter
• fadeev_av Posts: 6

  November 8, 2013 2:58AM

  Sorry, I had a more detailed analysis of the problem.
  The error does not appear if you delete one record. Spread the sample on this post. In the form which it has generated Source Control
  [code]
  EXEC(N'INSERT INTO [dbo].[MX_WF_ObjectStructure] ([ID_WF_Object], [ID_Object_Type], [Parent_ID], [NameRU], [NameEN], [Table_Name], [PK_Field], [ID_WF_UsingObject], [Edit_Field], [Field_Type], [FK_Field], [WhereClause], [Field_List], [Value_List], [Get_Method], [Set_Method], [ID_Journal], [JournalPK], [JournalField], [ID_LogicType], [Default_Value], [Edit_Mask], [Visible_Condition], [Enabled_Condition], [Required_Condition], [Dictionary_Condition], [Constraint_Condition], [Constraint_Message], [ID_Sheet], [IsPublished], [OrderNum], [Display_Name], [Display_Rows], [CreateDate], [ID_User], [UpdateDate], [Note], [Filter_Condition], [Use_In_Templates], [Editing_Condition], [Filter_Func], [ID_Form], [FormScript], [ID_WF_ImportObject], [Import_Method], [ShowInFilter], [Colored], [DisplayButton], [ClearIfNotVisible], [UseInGroupUpdate], [Display_Name_ENU], [ColumnNumber]) VALUES (16018258, 3005, 14949701, N''ИÑ

  0 · Share on Twitter