Print Thread
Control window type by "Pragma" in SQL file?
#62634 07/08/21 07:42 AM
Joined: Apr 2020
Posts: 21
Germany
D
Member
OP Offline
Member
D
Joined: Apr 2020
Posts: 21
Germany
Servus Marko,

we like to use the PSD a lot smile - Thx!!


We store SQL snippets in .SQL files. When I open them via object browser - the "default" command window is not always the best choice.

Question: is it possible to compare with

-- TAB=This is my TAB name

by such a special comment to control the window type at "Defaullt-Open"?

I remember dark that "years ago" in PSD, there was something similar in test scripts to assign them to the test.window.

Ahoy Daniel

Re: Control window type by "Pragma" in SQL file?
D.Wenzel #62635 07/08/21 08:50 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
If you go to Preferences > Files > Extensions you can associate the .sql extension with the SQL Window.


Marco Kalter
Allround Automations
Re: Control window type by "Pragma" in SQL file?
D.Wenzel #62637 07/08/21 11:22 AM
Joined: Apr 2020
Posts: 21
Germany
D
Member
OP Offline
Member
D
Joined: Apr 2020
Posts: 21
Germany
Thx for the quick answer. The commandwindow is the best standard for ".SQL" files in our case. Another file extension is not useful at the moment.

Maybe this is a change request for the future.

Ahoy Daniel


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.030s Queries: 14 (0.007s) Memory: 2.5046 MB (Peak: 3.0420 MB) Data Comp: Off Server Time: 2024-05-19 23:56:59 UTC
Valid HTML 5 and Valid CSS