D. Scott
Jan 26, 2017 9:57:41 AM

Can a SQL RESULTS Tab/Pane be frozen?

I was hoping that there was a function for freezing the RESULTS Tab/Pane so that another new SQL SELECT could be executed without destroying a previous SQL SELECT, which could have taken many minutes to execute.  Currently those results are lost when a new SQL is executed, thereby losing time and adding frustration to SQL Analysis work.

 

Please advise; thanks!

D. Scott



Anonymous
Jan 26, 2017 9:59:00 AM

Can a SQL RESULTS Tab/Pane be frozen?

PS.  I should note that my current version is 8.5.



Synametrics support engineer
Jan 26, 2017 10:19:27 AM

Can a SQL RESULTS Tab/Pane be frozen?

I recommend you create a new Query Page and run your second query in that page. To create a new Query Page, click the first button from left in the Toolbar. You can toggle between pages by selecting the desired page from Available Query Pages combox.

 



Anonymous
Jan 26, 2017 10:44:05 AM

Can a SQL RESULTS Tab/Pane be frozen?

Thanks for the suggestion.  

I guess that works but it would be quicker to compare results if they were in different side-by-side Tabs.

Thanks again for the repsonse!



Synametrics support engineer
Jan 26, 2017 10:53:08 AM

Can a SQL RESULTS Tab/Pane be frozen?

Scott,

Version 10.0 of WinSQL allow you to save the contents of a grid so you can view it later on. See image below.

 

Navigation

Social Media

Powered by 10MinutesWeb.com