You will no longer receive e-mail notifications from this forum.
Log-In to post
Anyone else having problems with Nav dying frequently? This started awhile back, but it has continued. Seems sort of random as I cannot figure out a pattern. Sometimes it dies while I'm doing something in Nav and sometimes I just come back and it's non-responsive.
Also in Windows 10, I almost always get a second "shadow" window that gets created on the task bar.
I have sent Vincent the sqlnavigator.el file from the incident that occurred yesterday.
Just encountered a problem with the formatting tool CTRL+R :
In version 7.4 beta, the aliases go on the next line. I copied my parameter from 7.3 to 7.4, but nothing changes.
Here my parameter file :
<SQLNavFormatter><SQLNavOptions Version="18.104.22.16848" Created="2015-12-02 09:31:08" Modified="2016-01-12 11:38:52"/> <QP5FormatterOptions><OptionsGUI>5.290.0</OptionsGUI> <Version>252</Version> <OutputTabs>2</OutputTabs> <IndentSize>2</IndentSize> <IndentTHENonSameLine>1</IndentTHENonSameLine> <IndentLOOPonSameLine>1</IndentLOOPonSameLine> <IndentISonSameLine>1</IndentISonSameLine> <RightMargin>128</RightMargin> <LF_LimitLinefeeds>0</LF_LimitLinefeeds> <VariableCase>2</VariableCase> <CommaStyle>2</CommaStyle> <ParensStyle>0</ParensStyle> <CaseAllowFlat>0</CaseAllowFlat> <DefaultArrangeOnCol>99</DefaultArrangeOnCol> <DefaultListParens>3</DefaultListParens> <CreateTableArrangement>D</CreateTableArrangement> <CreateTableListParens>6</CreateTableListParens> <CreateViewArrangement>D</CreateViewArrangement> <CreateViewListParens>6</CreateViewListParens> <RecordTypeArrangement>D</RecordTypeArrangement> <CreateTypeArrangement>D</CreateTypeArrangement> <CreateTypeListParens>6</CreateTypeListParens> <Tagline>0</Tagline> </QP5FormatterOptions></SQLNavFormatter>
If I set a category on a connection in the project Manager and then try to open the connection, it doesn't keep the category in the popup logon window.
If I have saved the password it does keep it.
Thought that I already had opened a thread therefore, but I don't find it anymore !
A copy / paste from 67000 lines of code takes about 5-7 minutes (SQL Nav is not responding), since at least V 7.2
I'm in v 22.214.171.12467, 32bit on Win 7 pro (up to date), I5 M520 CPU 2.4Mhz, 4G ram (2.4 used from 3.2 available), SSD drive
In V6.7 the same copy/paste takes +/- 3 seconds !
It's the second time, the CTRL+R crashes and resets my parameters. Bot times, I just added some code, and pressed CTRL+R. Got this error :
I recopy my backup file in the directory and CTRL+R works again !
I was wondering if there is any plan for moving the SQL Navigator folder (binaries files) from...
"C:\Dell\SQL Navigator 2016 Suite" to "C:\Program Files\SQL Navigator 2016 Suite" for example
I think it was just an issue with a session
Download Beta build expiring on 30-Apr-2017
Download Beta (64-bit)
SQL Navigator Team
Just opened the triggers from a table, it took 10 seconds to show them in the right window !!!
I closed all SQL Nav and restarted one session, same result :
It does this behaviour with all the triggers and indexes, not the others parts of a table.
session => new session
click ok..AAANNNDDDD.. Wait.
ok it's connected in about 3 seconds - but it feels like forever. Which gets old when you log into 6 databases in the AM.
Ok, so, when I go to do an explain plan, nav asks me to create the table if it can't find it. This is fine, but it always asks twice if I say no.
Just dropped a view in SQL Nav 7.4 beta 32bit an got this :
Prerequisites:1. Object need to be locked ONLY in VSS Visual Sourse Safe (I use SQL nav 7.1 to do it)
Step 2What i do:Navigate to object locked at step 1
What i need to see:Object is locked
What i see:I can CheckOut object
Step 3I CheckOut locked objectWhat i see:Warning File already checked out and thenObject State become Checked Out.
In log:09:52:08 Visual Source Safe Error: User already has file checked out09:52:11 Error checking out file: FORPOST.SRL_GISGKH_API.PSK.
Step 4:I try to undo CheckOut object at step 3
What i see:Message in log
In log:10:53:54 File $/FORP/FORPOST.SRL_GISGKH_API.PSK is not checked out10:53:54 Error performing VCS undo check-out of: Operation aborted
Maybe I missed some Team coding settings?
Please add the possibility to bind a clob field.
We are working on test database.
It will be "Killer Feature" to export data from select with UPDATE.
I think process will be like:
How do you transfer settings from test to work database?
In SQL Navigator 7.2 formatter did this:
SELECT column_1, column_2, column_3, column_4, column_5, column_6, column_7, column_8, column_9, column_10, column_11, column_12, column_13 FROM DUAL;
Just one space too much in the second line, but still acceptable.
String Concatenation - Style = "Stack only on overflow" did not work.
Now we have this:
-- Spacing - Margins - Right Margin = 110 -- Operators & Punctuations - String Concatenation - Style = "Stack only on overflow" SELECT column_1, column_2, column_3, column_4, column_5, column_6, column_7, column_8, column_9, column_10, column_11, column_12, column_13 FROM DUAL; SELECT column_1 || column_2 || column_3 || column_4 || column_5 || column_6 || column_7 || column_8 || column_9 || column_10 || column_11 || column_12 || column_13 FROM DUAL; -- Spacing - Margins - Right Margin = 110 -- Operators & Punctuations - String Concatenation - Style = "Stacked" SELECT column_1, column_2, column_3, column_4, column_5, column_6, column_7, column_8, column_9, column_10, column_11, column_12, column_13 FROM DUAL; SELECT column_1 || column_2 || column_3 || column_4 || column_5 || column_6 || column_7 || column_8 || column_9 || column_10 || column_11 || column_12 || column_13 FROM DUAL;
Looks like it completele ignores the Right Margin setting.
String Concatenation - Style = "Stack only on overflow" still does not not work.
Prerequisites:1. Option "Include Schema in DDL" is OFF2. Schema is configured in project config file3. Different versions of Package body in Other user Schema under Team Codding
What i do:1. Navigate to Package body in Other user Schema2. Try to Get Lastest revision on Package body
What i need to see:OK & Reload object
What i see:10:30:26 ORA-24344: success with compilation error10:30:26 1/14 PLS-00201: identifier 'SRL_UNIFO_3' must be declared10:30:26 1/14 PLS-00304: cannot compile body of 'SRL_UNIFO_3' without its specification10:30:26 PL/SQL: Compilation unit analysis terminated
If you do this:
select * from user_tables ut WHERE ut.table_name NOT IN (SELECT * FROM user_tab_cols tc WHERE tc.
the suggest box flashes, but doesn't stay on the screen after you type the last "."
Even if you add the final ")" it still doesn't display. Seems like this should work.
Ok, I have reinstalled Nav on a Windows 10 box and now I cannot keep the list of my open sessions at the top of the screen. I move it, but it doesn't get saved there.
What's the trick here?