How to view content of a long string variable (VB6)

Topic

New Reply

During run time, I need to check SQL statement which is assigned to string variable strSQL and can be 400 hundreds characters long. When use Watch Window, I can only manage to see max abt 250 characters at Value area, while the end part of the string is trimmed off but only that part is what I m interested in. Can anyone tell me how to view the full content of long string variable?

Thanks
David

Reply | Quote

Replies

You can either temporarily put a statement

MsgBox strSQL

in the relevant place(s) in your code, or put a breakpoint there, and type the same statement into the Immediate window when the code pauses.

Reply | Quote

Thank you Hans!

Reply | Quote

Use Immediate window and debug.print, either within the code itself, or in the Immediate window directly.

Reply | Quote

When I have very long string variables that I need to watch, I create a dummy label control or text box on a form. Then I set the label caption (or text for the text box ) equal to the string via code.

Reply | Quote