Author |
Message |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7907
|
|
|
|
In response to evans036
|
|
it does not seem to work with Aqua Data Studio (which is the primary database tool i use). it gives me error: 'Unsupported window class (SunAwtFrame)' when i try to register that app. RATS!
so i have been playing with it in ultraedit and i like it.
however: i work with many oracle schemas (we have about 300 on our prod database server). i am generally working with 2/3 schemas for any particular project. is there a way in SA that we can at least set a default schema (which is not necessarily the one i log in under) so that i can just see those tables? |
Would you please start a separate topic to make it easier to reply to your message, rather than having all postings in the same message thread?
You can use Notepad or Wordpad to edit your queries (they come for free with every Windows system :) )
Please check SQL Assistant options, see DB Options tab ->DB Queries group -> Context queries. You will see how the default schema is calculated, and if needed, you can modify that query and set it to return whatever you want as the default schema name.
|
|
Tue Jun 28, 2011 5:23 pm |
|
|
knechod
Joined: 28 Jun 2011 Posts: 4 Country: United States |
|
Hooking to other editors |
|
|
|
in response to
|
|
I tried to follow your instructions to register WordPad, but the Ctrl-F5 combination did not work. I did check to make sure Ctrl-F5 worked in SSMS (Parse). |
The combination is Ctrl+Shift+F5 and it works fine in Wordpad. Please give it a try. |
Yes, I read further down in the documentation, and it did mention adding the Shift. I did so, and I got the SQL Assistant window up.
However, when I started typing:
|
|
USE DATABASE
GO |
It ended up with:
|
|
USE DATABASE
GGO |
Additionally, when I highlight a statement and execute it, it returns an error that says:
Executing selected queries... Please wait or close this tab to cancel execution.
Msg 2812, Level 16, State 62, Could not find stored procedure 'u'.
The command(s) completed with errors (0.58 ms).
In other words, it tries to execute the first character as a stored procedure.
|
|
Tue Jun 28, 2011 8:17 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7907
|
|
|
|
|
|
Additionally, when I highlight a statement and execute it, it returns an error that says:
Executing selected queries... Please wait or close this tab to cancel execution.
Msg 2812, Level 16, State 62, Could not find stored procedure 'u'.
The command(s) completed with errors (0.58 ms).
In other words, it tries to execute the first character as a stored procedure. |
I have reported this issue to dev. team. Tracking number #SA0014768
|
|
Thu Jun 30, 2011 9:41 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7907
|
|
|
Tue Jul 05, 2011 6:58 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7907
|
|
|
Tue Jul 19, 2011 9:15 am |
|
|
gemisigo
Joined: 11 Mar 2010 Posts: 2141
|
|
|
|
This version has expired. Is there a new one available for download?
|
|
Mon Aug 15, 2011 7:04 am |
|
|
neverden
Joined: 02 Dec 2008 Posts: 58
|
|
|
|
|
|
This version has expired. Is there a new one available for download? |
I need this too!
|
|
Mon Aug 15, 2011 7:10 am |
|
|
BillR69
Joined: 11 May 2007 Posts: 29 Country: United States |
|
6.0.42 Expired |
|
Is there another beta release? 6.0.42 is saying it is expired today.
|
|
Mon Aug 15, 2011 9:04 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7907
|
|
|
|
I think no. We are readying the retail version for release. Hope to see it released this week. Please stay tuned.
|
|
Mon Aug 15, 2011 10:15 am |
|
|
benpage
Joined: 10 Aug 2011 Posts: 6 Country: United States |
|
|
|
So we have to reinstall the old version to keep working while we wait?
|
|
Mon Aug 15, 2011 1:22 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7907
|
|
|
|
I apologize for the inconvenience. Please disable or uninstall the beta version. Your previous version is still installed and intact. You simply need to start it manually
|
|
Mon Aug 15, 2011 1:59 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7907
|
|
|
|
SQL Assistant beta is now officially closed. SQL Assistant version 6.0 was released today. Thank you to everyone participated in the closed beta. And thank you to all of you for your continued patience and support
|
|
Thu Aug 18, 2011 2:45 am |
|
|
|