Instead of a sub use a function that returns STATUS_RETURN_CODE. Exampel code in C#:
public STATUS_RETURN_CODE ReplicationStatus(string message, int percent)
{
this.label1.Text = message;
this.progressBar1.Value = percent;
return STATUS_RETURN_CODE.SUCCESS;
}

Anonymous User 12/2/2004 4:51:20 AM

I think that the event handler changed between SQL Server 2000 SP2 and SP3. Make sure that you are using SP3. After I upgraded to SP3, it worked for me.
Thanks,
Glenn Gailey [MS]
This information is provided "AS IS" with no warranties, and confers no rights.





GlennG11/15/2004 9:27:52 PM

There is a problem with the code on the following line:
AddHandler myMergeObj.Status, New _SQLMergeEvents_StatusEventHandler(AddressOf myMergeObj_Status)

Its telling me the following:
Method 'Private Sub myMergeObj_Status(message As String, percent As Integer, ByRef retCode As SQLMERGXLib.STATUS_RETURN_CODE)' does not have the same signature as delegate 'Delegate Function _SQLMergeEvents_StatusEventHandler(Message As String, Percent As Integer) As SQLMERGXLib.STATUS_RETURN_CODE'.

AND
Method 'myMergeObj_Status' cannot handle Event 'Status' because they do not have the same signature.


Anyone get this to compile?

Thanks,
Greg

Greg Knierim 9/30/2003 6:10:56 AM

Just a note about wiring event handlers - the use of 'WithEvents' and 'Handles' is enough to wire an event in VB.NET. 'AddHandler' is a separate way to wire events. In other words, you can use either AddHandler or WithEvents/Handles to wire your Status event. If you decide to use AddHandler you don't even need to include 'WithEvents' in your object declaration.

See MSDN:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcn7/html/vaconUnderstandingEventHandlers.asp

Matt Hostetler 6/27/2003 6:46:26 AM