Re: Filtering and Parent-Child Relation

With join filters this should work. What exactly is happening? Are you
inserting parent and child rows on the publisher and only the parents are
arriving? Did you check the conflict viewer?

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



<savvaschr@xxxxxxxxxxxxxxxx> wrote in message
news:1163059365.843974.186380@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello

I would like to ask something about filtering Rows on a Merge
Replication and about Parent-child table relations.

I had one filter that on a Parent Table that the filter was depending
on the Child of that table.

For example I have one table called Accounts lets say with 2 columns
AccountID ans AccountName
and a child table called AccountRoutes with also 2 columns AccountID
and RouteID.

My filter was like this
Select * From Accounts where AccountID IN
(Select AccountID From AccountRoutes)

The problem with this Filter was that data from Account Table that
should come on the subscriber were not coming through.

I know that the Paernt in the Replication is usually(I checked my
Nicknames From SysMergeArticles)
updating First and than the Child. But I thought that if the parent
Filter is based on the Child and the Child is not updated yet then the
parent will not take the correct data at the end.

So i said that there must be a Rule to that .

A Parents Filter cannot depent on its Child.

Is my Rule Correct? And if Yes then if this is my data structure and i
cannot change it then how can I achive this Filtering?

Thanks

Savvas Christodoulou



.

Relevant Pages

  • Child Aggregate Filter Not Recognising Newly Added Child Rows (ADO.NET 2.0 Dataset)
    ... reflect in any aggregate filter placed upon the parent table. ... Public Sub FillParent() ... (i.e. the filter does not recognise the new child rows). ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Still trying to clear cobwebs...
    ... Almost forgot a key detail The criteria I'd like to filter ... on is not in the child table, but in another related table that is M:1 to ... >field to bind the parent to. ...
    (comp.databases.paradox)
  • Filtering and Parent-Child Relation
    ... I had one filter that on a Parent Table that the filter was depending ... and a child table called AccountRoutes with also 2 columns AccountID ...
    (microsoft.public.sqlserver.replication)
  • Re: select record based on record selected in the child form
    ... The Parent form and subform use the same table as the record source. ... the child records reset and the pointer was no ... 'THIS PORTION OF CODE WORKS TO FILTER THE PARENT FORM ... frmInvoice has subform frmInvoiceLineAddSubform based on ...
    (microsoft.public.access.formscoding)
  • Re: select record based on record selected in the child form
    ... The Parent form and subform use the same table as the record source. ... the child records reset and the pointer was no ... 'THIS PORTION OF CODE WORKS TO FILTER THE PARENT FORM ... frmInvoice has subform frmInvoiceLineAddSubform based on ...
    (microsoft.public.access.formscoding)