other text editors that support SQL assistant for windows ?

Hi,
I know that Notepad and Notepad++ works well with SQL assistant, but I'm looking for another text editor that support SQL assistant.
I tried Emacs and VIM but they didn't work.

Have you tried the SQL Editor bundled with SQL Assistant?

	SysOp wrote:
	Have you tried the SQL Editor bundled with SQL Assistant?

There's an editor bundled with SA? Is that new or something that eluded my attention so far?

gemisigo wrote:

	SysOp wrote:
	Have you tried the SQL Editor bundled with SQL Assistant?

There's an editor bundled with SA? Is that new or something that eluded my attention so far?

It's mentioned in the documentation but I've never found a way to use it.

	Mindflux wrote:
	It's mentioned in the documentation but I've never found a way to use it.

Hahaha, I can't believe it :) It's really there (C:\Program Files (x86)\SQL Assistant 6\data\sqleditor.exe). I guess it was hiding silently in the shadows all these years :) If I had knew...

gemisigo wrote:

	Mindflux wrote:
	It's mentioned in the documentation but I've never found a way to use it.

Hahaha, I can't believe it :) It's really there (C:\Program Files (x86)\SQL Assistant 6\data\sqleditor.exe). I guess it was hiding silently in the shadows all these years :) If I had knew...

Yeah I found that too, but when I run it it gives me:

---------------------------
SQL Assistant - Error
---------------------------
Can't find registered target for "SQL Assistant code editor"
---------------------------
OK
---------------------------

Strange. I get this neat little editor:

Finally got it to work, hrmm.

Though the connection wizard always comes up as Oracle... .

When I go to options via the sqleditor.exe pulldown all of my options are ENTIRELY different from what's in my task bar.. none of my code formatting or anything is here.

Where is this sql editor getting it's data from?

edit1:
It looks like it's reading C:\program files (x86)\SQL Assistant 6\data\sqlassist.sas rather than what's coming out of %APPDATA%\SQL Assistant\6.4\sqlassist.sas? (confirmed with procmon)

edit2:
This makes changing things difficult since a lot of stuff in C:\program files is NOT supposed to be user writable.

Last edited by Mindflux on Wed Jul 17, 2013 2:04 pm; edited 3 times in total

It was added in 6.3. For now it's quite simple, but we envision a bright feature for it.

oops double post

Last edited by Mindflux on Wed Jul 17, 2013 2:03 pm; edited 1 time in total

If you get an error when opening the editor, it means your SQL Assistant settings file is outdated and you need to upgrade it.

	SysOp wrote:
	If you get an error when opening the editor, it means your SQL Assistant settings file is outdated and you need to upgrade it.

I got it, the problem was there was no sqlassist.sas in C:\program files (x86)\sql assistant 6\data.

Right clicking sqleditor.exe and run as administrator fixed that by creating it, but it did not preserve my sql assistant preferences. (deleting the file again shows the error I mentioned above when attempting to launch)..

So I copied the one from %appdata% over and that worked (why they read two different configs makes no sense?)... and then if you want to preserve a setting you need to remember to run SQL Editor as administrator to write to Program Files (rather than %APPDATA%). This seems like a bug?

Yes, there seems to be quite a few glitches but I think this could evolve into something great. I don't think it could replace Toad or SSMS any time soon but I think it's nice to have it. I'm still struggling to transform SA into something portable for the occasions I'm not allowed to access the server remotely and installing anything on it is forbidden as well. It's painful to do anything in SMSS without SA nowadays and it's much worse when the client tools are not installed at all so the only editor available is Notepad, which is as hard as a rock and as dumb as a brick. Not to mention when you have to run sql from the command line (and stop laughing, it's not that funny :)

Mindflux wrote:

gemisigo wrote:

	Mindflux wrote:
	It's mentioned in the documentation but I've never found a way to use it.

Hahaha, I can't believe it :) It's really there (C:\Program Files (x86)\SQL Assistant 6\data\sqleditor.exe). I guess it was hiding silently in the shadows all these years :) If I had knew...

Yeah I found that too, but when I run it it gives me:

---------------------------
SQL Assistant - Error
---------------------------
Can't find registered target for "SQL Assistant code editor"
---------------------------
OK
---------------------------

There should be a full separate copy of SQLAssist.sa file in the same folder. The SQL Editor reads settings from that copy. If you want to change the default Oracle assistant type to something else, say SQL Server, in the editor click SQL Assistant -> Options menu. In the settings, in Registered Targets locate "SQL Assistant code editor" and change the settings to SQL Server.

If you don't have it in the settings, something isn't right. Somehow you got an old version or an old SQLAssist.sas

SysOp wrote:

Mindflux wrote:

gemisigo wrote:

	Mindflux wrote:
	It's mentioned in the documentation but I've never found a way to use it.

Hahaha, I can't believe it :) It's really there (C:\Program Files (x86)\SQL Assistant 6\data\sqleditor.exe). I guess it was hiding silently in the shadows all these years :) If I had knew...

Yeah I found that too, but when I run it it gives me:

---------------------------
SQL Assistant - Error
---------------------------
Can't find registered target for "SQL Assistant code editor"
---------------------------
OK
---------------------------

There should be a full separate copy of SQLAssist.sa file in the same folder. The SQL Editor reads settings from that copy. If you want to change the default Oracle assistant type to something else, say SQL Server, in the editor click SQL Assistant -> Options menu. In the settings, in Registered Targets locate "SQL Assistant code editor" and change the settings to SQL Server.

If you don't have it in the settings, something isn't right. Somehow you got an old version or an old SQLAssist.sas

When I got that message there wasn't even a SQLAssist.sas file in the \data folder. Once I ran sqleditor.exe as administrator it created one (but was off sync from my normal set of files). It's a bit odd storing the preferences file there since it requires elevated rights to even write to the directory. Maybe this will change with a later version.