 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
gemisigo
Joined: 11 Mar 2010 Posts: 2165
|
|
[SA 9.1.256 Pro] - Expand schema in SQLite |
|
Expanding schemas in SELECT popups no longer works with right arrow key in SQLite. Left arrow key does toggle (expands when folded and folds when expanded instead of simply folding it). Right arrow key only inserts the currently filtered/selected schema name into the editor (SQL Editor). The whole process works properly when connected to SQL Server.
|
|
Fri Mar 03, 2017 9:37 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Thank you very much for reporting this issue. I have logged it in the bug tracking system.
|
|
Fri Mar 03, 2017 10:28 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Actually, this is the intended behavior and we just tested it in both SQLite and MSSQL getting the same result. The Right Arrow inserts schema name with a dot which immediately triggers the Object names popup.
If that's not what you get, can you please attach a screenshot or short video demonstrating the issue?
|
|
Fri Mar 03, 2017 11:17 am |
|
 |
gemisigo
Joined: 11 Mar 2010 Posts: 2165
|
|
|
|
Hmm, it seems it has been a temporary glitch. I can no longer reproduce it but it was definitely there. I've had a database/schema name 'statisztika' attached to the database 'main' and whenever I typed 'SELECT' and then filtered on 'statisztika' by typing 'stat' and trying to expand it with right arrow the word 'statisztika.' was inserted into the editor without actually expanding the database/schema so I ended up with
 |
 |
SELECT statisztika.statisztika.statisztika.statisztika. Clicking the '+' would expand it.
|
with the popup still showing 'statisztika'.
Might it be a side-effect of upgrading 9.0 to 9.1? I've restarted both SQL Assistant and SQL Editor several times since.
|
|
Fri Mar 03, 2017 11:34 am |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|