FROM cmnt_dim a
ORDER BY a. <- this will not initiate the dot lookup window
A couple of issues/questions/bugs…
I’m a little confused about the DB Navigator vs. Code Editor issue. I have deselected the ‘Do not show DB Navigator Window after connection’ checkbox expecting the DB Navigator to show up first, not the empty code editor, but it doesn’t (assuming checking the box works as desired). In fact it’s very irritating that the code editor comes up at all because that assumes that you’re starting a “new” piece of code or sql every time you run sqlnav. I on the other hand rarely write a sql query from scratch. I typically hit F3 on a table from the navigator and let sqlnav write the sql for me then add the where clause etc.
When extracting DDL, what happened to the “Extract DDL Editors” section of the “Extract DDL” window that contained the two properties: Extract DDL to the same Editor and New Editor for each object? I am VERY disappointed that those are gone - I’m a data warehouse guy and I use those ALL the time. Please bring them back or tell me where they went. - thx
There appears to be a bug related to the “Dot Lookup” when doing an “ORDER BY” on a table. The “WHERE” clause will bring it up but not “ORDER BY”
SELECT a.cmnt_id, a.cmnt_txt, a.cmnt_md5, a.create_dtm, a.create_usr, a.last_upd_dtm, a.last_upd_usr
4. How can I remove the “Toolbox” button on the right margin?
- Is there a way to move the code editor tabs back to the bottom - or turn them off. The top is valuable real estate and them take up too much space. Also, I’m amazed the “beta community” didn’t like the Xs on each tab (like IE v7 etc). It’s VERY clunky having them on the right.
Otherwise I like this version so far
Thanks for letting me rant,