SQLDMO Subset Filter - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

SQLDMO Subset Filter

Author

Topic

gslim
Starting Member

3 Posts

Posted - 2005-03-21 : 18:24:27

Does anybody know the usage of the mergeSubsetFilter in SQLDMO. Right now I am doing the mergearticles.add but there appears to be no mergesubsetfilters.add option.


 objMergeArticle = MergeArticle("Macro_Plot", False)
			objMergePublication.MergeArticles.Add(objMergeArticle)
			objMergeFilter = MergeFilter("Macro_Plot", "MonEvent", "[Macro_Plot].MPlot_GUID = [MonEvent].MonE_MPlotGUID", True)
This Line Does Not Work objMergePublication.MergeSubsetFilter.add(objMergeFilter)

gslim
Starting Member

3 Posts

Posted - 2005-03-22 : 16:48:42

Found it. You have to add the subset filter to the merge article after you have added it to the publisher.


objMergeArticle = MergeArticle("Sub_Sample", False)
objMergeFilter = MergeFilter("Sub_Sample_Macro_Plot", "Macro_Plot", "[Macro_Plot].MPlot_GUID = [Sub_Sample].SSamp_MPlotGUID", True)
				objMergePublication.MergeArticles.Add(objMergeArticle)
				objMergeArticle.MergeSubsetFilters.Add(objMergeFilter)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources