SQL Window - Export Results - SQL file

[Bernhard S]

Why does the Export Results - SQL file
by default create a file with extension "sql". If you open that file again with PSD and you have created a list of many SQL inserts this way, you would have to mark them all in order to insert them all. Annoying is as well then that you get a new output tab for each insert, which can quickly become too much.

Wouldn't it be better to by default create a "pdc" extension file, that loads with PSd as a Command Window, where you can easily run all your inserts?
In a lot of cases it would also be very helpful to be able to just export the insert statements to clipboard and paste them then wherever you want in the same or another PSD project again.

 

[Marco Kalter]

It would indeed be better to use the primary extension of the Command Window. I have added this to the list of enhancement requests.

Export to Clipboard is also on the list of enhancement requests.

 

[Bernhard S]

Another annoyance I found: When you export tables with texts containing ampersands (&), it is taken as a substitution variable when executing in a command window! This can get very annoying and delivers wrong results too. There should automatically in such cases a

set define off

be at the top of the script to avoid such trouble.

 

[Marco Kalter]

I have added this to the list of enhancement requests.