SQL Navigator - Beta Forum - SQL Navigator Beta Program - Toad World

SQL Navigator Beta Program Community

SQL Navigator - Beta Forum

joethejet
Follow / 24 May 2017 at 4:24pm / SQL Navigator Beta Program

Nav Dies Frequently

Expand content
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...

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.

10 0 / Create an account to join the discussion.
martin_goblet
Follow / 15 May 2017 at 2:04pm / SQL Navigator Beta Program
Latest post by on 24 May 2017 at 7:15am

Formatting issue with the aliases.

Expand content
Hi 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...

Hi

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="7.3.0.4148" 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>

Regards

Martin

65 3 / Create an account to join the discussion.
joethejet
Follow / 14 Apr 2017 at 6:35pm / SQL Navigator Beta Program
Latest post by on 16 May 2017 at 7:01pm

Setting Category doesn't Stick

Expand content
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...

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.

87 2 / Create an account to join the discussion.
martin_goblet
Follow / 26 May 2015 at 1:18pm / SQL Navigator Beta Program
Latest post by on 16 May 2017 at 1:19pm

Copy / paste takes tremendous time !

Expand content
Hi 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...

Hi

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 7.3.0.3967, 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 !

Regards

Martin

1669 13 / Create an account to join the discussion.
alex.kloian
Follow / 2 May 2017 at 6:40pm / SQL Navigator Beta Program
Latest post by on 12 May 2017 at 9:33am

SQL Navigator Problem with TIMESTAMP formatted data exports to SQL...

Expand content
While using SQL Navigator 7.3 and 7.4 beta, when using the Export Data option to send data to Table INSERTs certain fields which contain dates & times (Oracle TIMESTAMP format) are not being formatted...
While using SQL Navigator 7.3 and 7.4 beta, when using the Export Data option to send data to Table INSERTs certain fields which contain dates & times (Oracle TIMESTAMP format) are not being formatted correctly within the SQL INSERT statements.  When the SQL INSERT statements that are generated by SQL Navigator are run they receive an error due to incorrect formatting of those TIMESTAMP fields.
 
This feature worked correctly in SQL Navigator 6.7.
 
In SQL Navigator 7.3 and 7.4 (using Oracle 12.x), an exported TIMESTAMP field would like this:
4/24/2017 4:00:15.000000 AM
 
In SQL Navigator 6.7 (using Oracle 12.x), an exported TIMESTAMP field would like this:
'24-APR-2017 4:00:15.000000 AM'
 
Samples appear below.
 
The information shown below was run in an Oracle 12.x database.
 
 
select
invoice_dt, pymnt_dt,pkt_hr_recvd_dttm,row_added_dttm, row_lastmant_dttm
from ps_pkt_empl_vchr
where voucher_Id = '02802760'
==>
INVOICE_DT               PYMNT_DT                 PKT_HR_RECVD_DTTM       ROW_ADDED_DTTM       ROW_LASTMANT_DTTM      
------------------------ ------------------------ ----------------------- -------------------- -----------------------
4/13/2017                4/27/2017                4/18/2017 9:08:20.00000 4/18/2017 9:07:27.57 4/24/2017 4:00:15.00000
-------- End of Data --------
 
 
desc ps_pkt_empl_vchr
==>
Name                           Data Type                    
------------------------------ ------------------------------
BUSINESS_UNIT                  VARCHAR2(5 BYTE)      NOT NULL
VOUCHER_ID                     VARCHAR2(8 BYTE)      NOT NULL
PYMNT_CNT                      NUMBER(*,0)           NOT NULL
EMPLID                         VARCHAR2(11 BYTE)     NOT NULL
NAME1                          VARCHAR2(40 BYTE)     NOT NULL
PKT_SSN4                       VARCHAR2(4 BYTE)      NOT NULL
PYMNT_GROSS_AMT                NUMBER(26,3)          NOT NULL
INVOICE_ID                     VARCHAR2(22 BYTE)     NOT NULL
INVOICE_DT                     DATE
REMIT_SETID                    VARCHAR2(5 BYTE)      NOT NULL
REMIT_VENDOR                   VARCHAR2(10 BYTE)     NOT NULL
PYMNT_SEPARATE                 VARCHAR2(1 BYTE)      NOT NULL
PYMNT_MESSAGE                  VARCHAR2(70 BYTE)     NOT NULL
PROCESS_INSTANCE               NUMBER(10,0)          NOT NULL
PKT_AP_RECVD_DTTM              TIMESTAMP(6)
PKT_PAY_EARN_LINK              VARCHAR2(20 BYTE)     NOT NULL
PAID_AMT                       NUMBER(26,3)          NOT NULL
PYMNT_DT                       DATE
PYMNT_ID_REF                   VARCHAR2(20 BYTE)     NOT NULL
TOTAL_REIMB_AMT                NUMBER(26,3)          NOT NULL
PKT_HR_RECVD_DTTM              TIMESTAMP(6)
PKT_HRAP_STATUS                VARCHAR2(2 BYTE)      NOT NULL
ERROR_MESSAGE                  VARCHAR2(254 BYTE)    NOT NULL
ROW_ADDED_DTTM                 TIMESTAMP(6)
ROW_ADDED_OPRID                VARCHAR2(30 BYTE)     NOT NULL
ROW_LASTMANT_DTTM              TIMESTAMP(6)
ROW_LASTMANT_OPRID             VARCHAR2(30 BYTE)     NOT NULL
 
 
SQL Navigator 7.3.0.4294 (64-bit) from within Windows 7:
 
INSERT INTO ps_pkt_empl_vchr
VALUES(TO_DATE('2017-04-13 00:00:00', 'YYYY-MM-DD HH24:MI:SS'),TO_DATE('2017-04-27 00:00:00', 'YYYY-MM-DD HH24:MI:SS'),4/18/2017 9:08:20.000000 PM,4/18/2017 9:07:27.572983 PM,4/24/2017 4:00:15.000000 AM);
 
 
SQL Navigator 7.4.0.53 Beta (32-bit) from within Windows 7:
 
INSERT INTO ps_pkt_empl_vchr
VALUES(TO_DATE('2017-04-13 00:00:00', 'YYYY-MM-DD HH24:MI:SS'),TO_DATE('2017-04-27 00:00:00', 'YYYY-MM-DD HH24:MI:SS'),4/18/2017 9:08:20.000000 PM,4/18/2017 9:07:27.572983 PM,4/24/2017 4:00:15.000000 AM);
 
SQL Navigator 6.7.0 (32-bit) from within Windows 7:
INSERT INTO ps_pkt_empl_vchr
VALUES(TO_DATE('2017-04-13 00:00:00', 'YYYY-MM-DD HH24:MI:SS'),TO_DATE('2017-04-27 00:00:00', 'YYYY-MM-DD HH24:MI:SS'),'18-APR-2017 9:08:20.000000 PM','18-APR-2017 9:07:27.572983 PM','24-APR-2017 4:00:15.000000 AM');
=================================================== This communication contains confidential Securitas Security Services USA, Inc. business information, and is intended for the addressee only. If you have received this message in error, or if there is a problem with the communication, please notify the sender immediately. The unauthorized use, disclosure, reproduction, forwarding, copying or alteration of this message is strictly prohibited. Participants in this communication are not permitted to exchange or transmit Personal Identity Information (PII) via unsecured email. PII includes: Social Security numbers, credit card numbers, bank and credit union account numbers, health insurance plan identification numbers, driver’s license numbers, dates of birth, and other similar information associated with an individual that, if misused, might compromise that person's personal or financial security.
77 1 / Create an account to join the discussion.
martin_goblet
Follow / 9 May 2017 at 1:04pm / SQL Navigator Beta Program
Latest post by on 12 May 2017 at 8:54am

CTRL+R resets the formater option file

Expand content
Hi 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...

Hi

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 !

Regards

Martin

35 2 / Create an account to join the discussion.
Rod
Follow / 3 May 2017 at 5:36pm / SQL Navigator Beta Program
Latest post by on 10 May 2017 at 3:06am

Hello there, I was wondering if there is any plan for moving the SQL...

Expand content
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"...

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

Thank you,

65 1 / Create an account to join the discussion.
joethejet
Follow / 4 May 2017 at 5:21pm / SQL Navigator Beta Program
Latest post by on 9 May 2017 at 10:35am

Nevermind

Expand content
I think it was just an issue with a session

I think it was just an issue with a session

41 1 / Create an account to join the discussion.
Vincent Liu
Follow / 28 Feb 2017 at 8:52am / SQL Navigator Beta Program
Latest post by on 2 May 2017 at 3:38am

SQL Navigator 7.4 beta build 33 (expiring on 30/Apr) is available

Expand content
Download Beta build expiring on 30-Apr-2017 Download Beta (64-bit) SQL Navigator Team

Download Beta build expiring on 30-Apr-2017

Download Beta (64-bit)

SQL Navigator Team

206 2 / Create an account to join the discussion.
martin_goblet
Follow / 10 Dec 2014 at 3:58pm / SQL Navigator Beta Program
Latest post by on 17 Apr 2017 at 6:32am

SQL Nav 7.2 Beta : display si to slow

Expand content
Hi 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...

Hi

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.

Regards

Martin

3067 5 / Create an account to join the discussion.
OracleDBA
Follow / 7 Apr 2017 at 4:37pm / SQL Navigator Beta Program
Latest post by on 11 Apr 2017 at 5:51pm

7.3.0 login is very slow

Expand content
session => new session select database 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...

session => new session 

select database

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. 

76 1 / Create an account to join the discussion.
joethejet
Follow / 25 Jan 2017 at 4:26pm / SQL Navigator Beta Program
Latest post by on 11 Apr 2017 at 5:07pm

Explain Plan asks for table create twice

Expand content
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.

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.

164 2 / Create an account to join the discussion.
martin_goblet
Follow / 11 Apr 2017 at 2:09pm / SQL Navigator Beta Program

Drop of a view

Expand content
Hi Just dropped a view in SQL Nav 7.4 beta 32bit an got this : Regards Martin

Hi

Just dropped a view in SQL Nav 7.4 beta 32bit an got this :

Regards

Martin

54 0 / Create an account to join the discussion.
Sergey Smith
Follow / 14 Feb 2017 at 6:05am / SQL Navigator Beta Program
Latest post by on 11 Apr 2017 at 8:29am

7.4.0.31 New team coding does not have exclusive lock?

Expand content
Prerequisites: 1. Object need to be locked ONLY in VSS Visual Sourse Safe (I use SQL nav 7.1 to do it) Step 2 What i do: Navigate to object locked at step 1 What i need to see: Object is locked What...


Prerequisites:
1. Object need to be locked ONLY in VSS Visual Sourse Safe (I use SQL nav 7.1 to do it)


Step 2
What 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 3
I CheckOut locked object
What i see:
Warning File already checked out and then
Object State become Checked Out.

In log:
09:52:08 Visual Source Safe Error: User already has file checked out
09: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 out
10:53:54 Error performing VCS undo check-out of: Operation aborted

P.S.

Maybe I missed some Team coding settings?

163 1 / Create an account to join the discussion.
Sergey Smith
Follow / 14 Feb 2017 at 7:36am / SQL Navigator Beta Program
Latest post by on 11 Apr 2017 at 6:56am

Add bind clob field

Expand content
Please add the possibility to bind a clob field.

Please add the possibility to bind a clob field.

134 1 / Create an account to join the discussion.
Sergey Smith
Follow / 6 Apr 2017 at 5:30am / SQL Navigator Beta Program
Latest post by on 7 Apr 2017 at 7:20am

Feature request: Export UPDATE

Expand content
We are working on test database. It will be "Killer Feature" to export data from select with UPDATE. I think process will be like: On dataset select "Export UPDATE" Select...

We are working on test database.

It will be "Killer Feature" to export data from select with UPDATE.

I think process will be like:

  1. On dataset select "Export UPDATE"
  2. Select primary key(s) column(s) for where
  3. Get Results

PS.

How do you transfer settings from test to work database?

99 2 / Create an account to join the discussion.
urs.metzger
Follow / 9 Jan 2017 at 8:55am / SQL Navigator Beta Program
Latest post by on 6 Apr 2017 at 11:30am

Formatter ignores right margin

Expand content
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; SELECT...

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;

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.

Regards, Urs

351 6 / Create an account to join the discussion.
Sergey Smith
Follow / 23 Mar 2017 at 5:37am / SQL Navigator Beta Program
Latest post by on 6 Apr 2017 at 8:43am

7.4.0.31 Team Codding Critical Problem - Get Lastest revision

Expand content
Prerequisites: 1. Option "Include Schema in DDL" is OFF 2. Schema is configured in project config file 3. Different versions of Package body in Other user Schema under Team Codding What i do...

Prerequisites:
1. Option "Include Schema in DDL" is OFF
2. Schema is configured in project config file
3. Different versions of Package body in Other user Schema under Team Codding


What i do:
1. Navigate to Package body in Other user Schema
2. 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 error
10:30:26 1/14 PLS-00201: identifier 'SRL_UNIFO_3' must be declared
10:30:26 1/14 PLS-00304: cannot compile body of 'SRL_UNIFO_3' without its specification
10:30:26 PL/SQL: Compilation unit analysis terminated

115 1 / Create an account to join the discussion.
joethejet
Follow / 20 Mar 2017 at 4:39pm / SQL Navigator Beta Program
Latest post by on 21 Mar 2017 at 2:14am

AutoSuggest doesn't work in this situation.

Expand content
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...

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.

122 1 / Create an account to join the discussion.
joethejet
Follow / 15 Mar 2017 at 6:00pm / SQL Navigator Beta Program
Latest post by on 20 Mar 2017 at 4:35pm

Keeping Toolbar in place

Expand content
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...

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?

153 3 / Create an account to join the discussion.