SqlDbx Forum

Mike

Guest

Copy / Paste

When I copy from results to editor strings get enclosed in quotes.
If I copy to external programe then strings are not in quotes.
How can i copy from results to editor without strings being in quotes.
Thanks

sqldbxhelp

Administrator

Re: Copy / Paste

By default when copying from Results grid to Script editor strings are enclosed in quotes and values are comma separated.
If you press Ctrl+Shift+V or use popup menu item Paste Special->Pate Grid Results Alt. then string will not be in quotes and
values will be separated by tabs

townscr

Member

Re: Copy / Paste

Have you ever considered ending each line with a comma when multiple rows are selected in the results pane?  I don't know how others are using it but I will usually select several rows of a column and paste it into a in() statement then add the commas.  I guess it would only make sense to do that when a single column with multiple rows are selected.

sqldbxhelp

Administrator

Re: Copy / Paste

There's an easier way to do it. Select values from one column and then select menu item from popup menu Generate->WHERE IN ()