The system didn’t see the changes.

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

The system didn’t see the changes.

Postby fadeev_av » Tue Oct 15, 2013 2:04 pm

In first data entering in the table (static data) the system can not track the changes.
Turned out that the problem arose because of the presence multi-values (varchar) in the generated script. After manual removal from this files all such lines, everything works fine. Is it a bug? Or explain me how I can fix this situation.
There is an example below:

[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'[ТипПродукта] <> ''ПлаÑ
fadeev_av
 
Posts: 5
Joined: Tue Oct 15, 2013 12:07 pm

Postby james.billings » Mon Oct 21, 2013 12:56 pm

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.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Postby fadeev_av » Tue Nov 05, 2013 2:39 pm

Create table sample:
Code: Select all
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'[ТипПродукта] <> ''ПлаÑ
fadeev_av
 
Posts: 5
Joined: Tue Oct 15, 2013 12:07 pm

Postby james.billings » Tue Nov 05, 2013 3:37 pm

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?
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Postby fadeev_av » Tue Nov 05, 2013 5:21 pm

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 ...
fadeev_av
 
Posts: 5
Joined: Tue Oct 15, 2013 12:07 pm

Postby fadeev_av » Wed Nov 06, 2013 10:28 am

Also, post the screenshots
This is a working copy and the recorded data in the table:
Image

This is the result of updating the state:
Image
fadeev_av
 
Posts: 5
Joined: Tue Oct 15, 2013 12:07 pm

Postby fadeev_av » Fri Nov 08, 2013 8:58 am

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''ИÑ
fadeev_av
 
Posts: 5
Joined: Tue Oct 15, 2013 12:07 pm


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 1 guest