Using the sample databases (WidgetStaging, WidgetProduction) and the "horizontal filter example
" and adding the vertical filter by inserting the following lines after line #46
- Code: Select all
TableDifference diff = m_TableDifferences["[dbo].[Widgets]"];
Before the change, the resulting script is:
INSERT INTO [dbo].[Widgets] ([RecordID], [Description], [SKU]) VALUES (8, 'New widget', 'NW')
After adding the code from the vertical filter example, the insert changes but the number of columns and the number of values is consistent:
INSERT INTO [dbo].[Widgets] ([RecordID], [SKU]) VALUES (8, 'New Widget')
I am not getting more values than columns in my case, but the "description" value has moved to the "SKU" column. Taking the SelectionDelegate out of the equation still yeilds the same result for row 8.
I'd assume this is a bug -- clearly the Engine is making an effort to remove the value from the results as well as the field name, but it's not removing the right value. I'll have to get back to you on this one.