Hi,
In COM conflict resolver, let's say, subscriber tries to upload an
INSERTED row to the publisher. By setting
rct = REPOLEAllChanges
in the IVBCustomResolver_GetHandledStates COM function I can catch all
the changes not only conflicts.
And in IVBCustomResolver_Reconcile function of the COM resolver, I
want to manipulate the INSERTED row from the source and eventually
insert that manipulated row to the destination. I tried
rrc.InsertRow
rrc.CopyRowFromSource
rrc.UpdateRow
but they did not work.
What is missing? What should I do to get an inserted row(Not updated
one, update works without any problem) from source in COM resolver
and manipulate it and INSERT it to the destination.
Any help would be greatly appreciated.
Thanks,
Nury SWORD
I found it, and would like to share it with the ones working on COM
conflict resolver before they suffer like me.
In COM conflict resolver, InsertRow is almost useless, it does not do
anything at all.
In Reconcile method, let's say a row is inserted from source to
destination, and you want to manipulate the inserted data row and
INSERT that manipulated row to the destination. In order to do that,
the sequence is :
SetColumn ...
SetColumn ...
...
(you manipulate as much columns as you want with SetColumn)
and then the magical ;
CopyRowFromSource method should be invoked. This is not documented in
anywhere, and I am happy to announce that.. I hope Microsoft includes
a little bit documentation about;
HOW TO MANIPULATE an INSERTED ROW (updated row is given as VB sample)
in COM Conflict resolver...
I hope that helps..
Nury Sword (MCDBA - MCSD)
Toronto
nurysword@.hotmail.com
Showing posts with label subscriber. Show all posts
Showing posts with label subscriber. Show all posts
Sunday, March 11, 2012
Subscribe to:
Posts (Atom)