SQL Assistant 6.2.109 is not work PLSQL Dev

SQL Assistant 6.2.109 is not work PLSQL Dev

Hi

I use PLSD Version 9.0.6.1665 on Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)
When I installed SQL Assistant 6.2.109, SQL Assistant do not work in PLSD.

So I reinstall SQL Assistant 6.1, then work fine.

I want to use SQL Assistant 6.2 in PLSD...

Please try the following: When focus in PLSD editor, press Ctrl+Shift+F5. What do you get?

I reinstalled SQL Assistant 6.2.109 and press Ctrl+Shift+F5 in PLSD editor.
Then SQL Assistant Target window opened.
And SQL Assistant context menu (right mouse button) is displayed.

It's OK.

Code snippet in list is very nice !!

Thank you

P.S. But when SQL Result is displayed (PLSD result, not SQL Assistant result),
cancel SQL Assistant column list by escape key, PLSD SQL Result is cleard and
PLSD raise error message "These query results are not updateable.
Include the ROWID to get updateable results.", "Cannot focus a disabled or invisible window"
This error still exists in Ver. 6.2.109...

Thank you. I'm glad to hear you got it working with PLSD.

Would you please describe step-by-step how to reproduce "Cannot focus a disabled or invisible window" error so that we can fix it in the next release?

Like This.
1. Open SQL Window and type SQL

	Code:
	select t.* from TableA t

2. Execute SQL, result is displayed.
3. Edit SQL, when space after 'where' is typed, Assistant window is displayed.

	Code:
	select t.* from TableA t where

4.To type ESC key, PLSD Large Data Editor Window is showed.
(Why ?)
5. Close PLSD Large Data Editor Window, to type 't.', Assistant window is displayed too
6. To type ESC key, PLSD error raise : "These query results are not updateable.
Include the ROWID to get updateable results."

Thanks. What you describe indicates a conflict for the usage of the ESC key. In step 3, when you use ESC while the focus is logically in the editor, PLSD senses that key-press and processes it as if the focus was in the result set. That sounds like a implementation limitation in PLSD, there seems to be no check for the input focus location when it is processing the ESC key-press. Note that the message is coming from PLSD, not SQL Assistant.

Try not to use the ESC key while PLSD result set is displayed, close it first.

Would you please describe how to reproduce ""Cannot focus a disabled or invisible window" error?

>Would you please describe how to reproduce ""Cannot focus a disabled or invisible window" error?
OK.
1.This is Step 3 screen shot.

2.When I type ESC key to close Assistant window, SQL Result is hide, and raise error.

3.Click OK Button , edit SQL and execute SQL, result is visible.
4.Edit SQL and open Assistant window.

5. Press ESC key to close Assistant window, PLSD raise error.

6. Click OK Button, PLSD raise error.

Thank you. Your detailed demonstration of the issue is very helpful. We should have a workaround available in the next public release
Issue tracking id #SA0014770