Hi, I have used the following microsoft code example:
Sub CreatePartial(strReplicableDBPath As String, _
StrDescription As String)
' This procedure creates a new, partial replica with global visibility.
' It assumes you are using the Northwind sample database, which contains
' the Customers table and the CustomersOrders relationship.
Dim repFull As New JRO.Replica
Dim repPartial As New JRO.Replica
Dim strPartialDBPath As String
' Open the partial replica in exclusive mode and create an
' expression-based filter in the partial replica.
repPartial.ActiveConnection = "Data Source=" & strPartialDBPath _
& ";Mode=Share Exclusive"
repPartial.Filters.Append "Customers", jrFilterTypeTable, _
"Region = 'CA'"
' Create a filter based on a relationship in the partial replica.
repPartial.Filters.Append "Orders", jrFilterTypeRelationship, _
' Repopulate the partial replica based on the filters.
Set repPartial = Nothing
I have a serious issue then trying to run the code in red. It states that the replica id already exists and this is onb first run.
Also, how do I create a relationship saying:
SELECT * FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID
so that only an order by the customers populated in the customer table is inserted.
I have done this as an easy example as the query I am actually doing will be a lot more complicated.
Does the relationships have to be set up for it to work or can you just do the relationship in the filter clause on the replication filter command????