Posted - 04/22/2012 : 13:53:37
| Hi, I hope someone can help explain how merge filters work.
My problem (simplified and reproduced) is this... I have a filter on a customer table that filters by name for example... i.e. select from customerTable where customer name like '%liquor%'
I can initialize the snapshot and my subscriber on (windows CE device) and I do see that the filter yields only customers with 'liquor' in their name. Good.
I can 'update' a different customer record and add 'liquor' to their name, sync my subscriber and indeed I get 1 new record downloaded and inserted. Good.
Now, if I take that same record and update the name to remove the word 'liquor' from the name and sync my subscriber, I *do not* see that same record deleted from the subscriber. I just get 0 inserts, updates and deletes. Not good.
There is just something I don't understand about the flow of how and when the filters are checked. Or I am doing something wrong but I have no clue what.
Can anyone shed some light on this for me? Much thanks!
More info.... I am using parametrized filters and joining this customer table based on salesperson group table in a many to many join... but I also have the filters checking for active customers in an 'Active' view so that I can weed out customers for various reasons (i.e. expired etc.) which helps keep the number of records down.
INNER JOIN [dbo].[Customer]
ON [SalespersonGroupDetail].[SalespersonNo] = [Customer].[SalespersonNo]
EXISTS (SELECT [Customer].[CustomerNo]
([Customer].[CustomerNo] = [Customer_ActiveOnly].[CustomerNo])))
Maybe this configuration isn't supported or something but it is working ok, just not yielding what appear to be correct results for me.
After more testing, it appears that any change to the record set at the publisher that causes a record to be inserted or updated at the subscriber seems to work. However any change at the publisher that would cause a record to be deleted at the subscriber doesn't seem to generate the corresponding delete. delete_tracking is enabled. Even an actual 'delete' record at the publisher is not being propagated to the subscriber.
Edited by - thebeezle on 04/23/2012 09:34:04