Special copy/paste visual basic

[Frank N]

I write Oracle queries in ASP pages. I use PL/SQL Developer to develop and test SQL queries before 'Special Copy VB' and paste into an ASP page. I've found that on pasting each single space is doubled. Generally this is just a minor nuisance where each single space between words becomes two. However there are situations where I only want a single space e.g. null(xxxx, ' ').
Am doing something wrong or is it a bug?

 

[Marco Kalter]

Works fine for me. Did you modify (or create) the copy definition? Perhaps you can send me the corresponding file from the SpecialCopy subdirectory in the PL/SQL Developer installation directory?

 

[Frank N]

Thanks for the reply.

Yes I did modify the copy definition.

As follows:
theSQL = " " & vbNewLine
theSQL = theSQL & " " & vbNewLine
theSQL = theSQL & " "

But since sending my question i found that removing one/both spaces inside the " " fixes the problem.
i.e.
theSQL = "" & vbNewLine
theSQL = theSQL & "" & vbNewLine
theSQL = theSQL & ""