Quote Originally Posted by dilettante View Post
I'm not sure what you think you are "seeing" in the Immediate window that tells you any more than just printing the parameter values passed.
if you print the sql out to the immediate window, you get this: "insert into tbl(f1, f2) values (?, ?)"
What Sam would rather see is: "insert into tbl (f1, f2) values ('value 1', 'value 2')"
I can understand that. There are times when I wished I could see the complete SQL with the parameter values in their proper spots, and capture the whole SQL.
The problem with that is it assumes that the parameters are replaced by the values, which isn't really the case. So it sometimes makes debugging a bit of a pain.
It seems to work for him, so why not? I on the other hand work on systems that deal with the O'Brien's and O'Leary's and the Al'Abrim's of the world, so stringing SQL Statements together don't work for me.

-tg