Check full value of a long string in the VB6 IDE

Question

I have a string 'sSQL' that contains a very long tsql statement. I need to check what its value is while debugging. I usually just use ?sSQL in the immediate window but this is truncating the first half and only giving me the end half.

So is there an alternative way to see the full value using the vb6 sp5 dev environment?

Answer 1

For debugging, Clipboard.Clear: Clipboard.SetText ssql then paste into notepad.

Answer 2

While execution is paused on the breakpoint you could type in the immediate window:

Debug.Print(sSql)

;-)