[SA 9.0.166 Pro] - Database dropdown disabled [FIXED]

[SA 9.0.166 Pro] - Database dropdown disabled [FIXED]

I frequently notice that the database dropdown list is gets disabled in SQL Editor. It does not show the current database and it cannot be clicked. Current database still can be changed with USE statement and reconnecting is a temporary cure. I've got no idea of its cause.

Last edited by gemisigo on Fri Nov 04, 2016 6:15 pm; edited 1 time in total

If you can reproduce it, please take a look if any connection related exceptions are written to SqlAssist.log file. Executing any SQL command restores connections automatically.

If you find such exceptions logged, please let us know.

No errors or exceptions in the log. The funny things is that it's actually the USE statement that trigger this. Happens both on ODBC and ADO connections to SQL Server.

Thank you so much for reporting issue. It's easily reproducible and totally explainable how come that no one has noticed it before. I have logged it under #SA0029945.

As a temporary workaround, to re-enable the drop-down without reconnecting, click the Refresh Cache button on the toolbar, which is to the left of the Database drop-down.

Yes, usually the database context is switched using the dropdown but when I'm into typing its much more convenient (and faster) not to move my hand to the mouse and back, since typing USE + database name with autocompletion and executing that statement is pretty quick on its own. Another use case is scripts that have to jump around databases to complete their goals.

Thank you for the workaround.

By the way, could you add hotkeys for triggering the connection dialog and cache refresh, please?

	gemisigo wrote:
	By the way, could you add hotkeys for triggering the connection dialog and cache refresh, please?

I know it's not a hotkey but you can hit F5 when any S.A intellisense popup comes up.

so us(e) pops up, hit F5. (three keystrokes).

Until they integrate a hot key that is.

Thank you for the suggestion. I created a new enhancement request #SA0029948

	Mindflux wrote:
	I know it's not a hotkey but you can hit F5 when any S.A intellisense popup comes up. so us(e) pops up, hit F5. (three keystrokes).

That's exactly what I've been doing for quite a some time and I'd be going happy about it except that I experienced pressing F5 on a popup occasionally executes the code in the editor. Happens very rarely and I cannot reliably reproduce it but it had proven to be a disaster a few times in the past :)

gemisigo wrote:

	Mindflux wrote:
	I know it's not a hotkey but you can hit F5 when any S.A intellisense popup comes up. so us(e) pops up, hit F5. (three keystrokes).

That's exactly what I've been doing for quite a some time and I'd be going happy about it except that I experienced pressing F5 on a popup occasionally executes the code in the editor. Happens very rarely and I cannot reliably reproduce it but it had proven to be a disaster a few times in the past :)

I have the inverse problem where I press enter on a statement and the popup is suggesting bracketed items like WITH (NOLOCK) at times and I press F5 to execute my statement and all it does is refresh my SQL Assistance cache.... which is equally annoying in a way less catastrophic way.

Ctrl+space then f5 works without adding any characters to the editor as well.