0

I have a bunch of print statements in a SP that tell me exactly what went wrong in the SP (if anything), but I cannot figure out how to capture the text in the

PRINT 'Receiver and Customer don''t match'

statements...

I pretty much want to get the info with the SP is executed, store them in a string and show the in a message box.

Is it even possible in VB6? I know you can do it with the .NET stuff, but cannot find any info on doing it in VB6.

3
Contributors
3
Replies
4
Views
9 Years
Discussion Span
Last Post by rrocket
0

Hi,

Declare Events for the Connection:
Write this at FormLevel :

Dim WithEvents MyMsg As ADODB.Connection

'and collect the Events in event:
Private Sub MyMsg_InfoMessage(ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, ByVal pConnection As ADODB.Connection)

MsgBox pError.Description

End Sub

I have not used, but it is done this way only..

Regards
Veena

0

Thanks for the suggestion. I actually found this http://support.microsoft.com/kb/294178, but never got everything to work correctly. We actually are switching to output params so life will get much easier (IMO) by doing it that way instead of messing with the print statements.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.