RE: Re: Formatter in TOAD for Oracle 11.6

Hi Tomas,

We keep the QP5 dll up to date with our Toad betas, so look for this fix in the beta within the next week or 2.

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of t_rott
Sent: Wednesday, November 21, 2012 4:34 AM
To: [email protected]
Subject: [toad] Re: Formatter in TOAD for Oracle 11.6

Thanks for so fast help.
Do you have a link for me to download the fixed version of the .dll file? 

Tomas

--- In [email protected], Andre Vergison <andre.vergison@...> wrote:
>
> Fixed.
> This statement didn’t format because the table reference did not not start with a join, which I agree doesn’t make sense.
> The fix will be in file qp5.dll as of version 5.242.
> 
> Thanks for reporting,
> Andre
> ________________________________
> From: [email protected] [mailto:[email protected]] On Behalf Of Andre Vergison
> Sent: dinsdag 20 november 2012 17:07
> To: [email protected]
> Cc: Michael Staszewski
> Subject: RE: [toad] Formatter in TOAD for Oracle 11.6
> 
> It’s a bug in the formatter due to recent changes to join formatting. I’ll look into this.
> Andre
> ________________________________
> From: [email protected] [mailto:[email protected]] On Behalf Of Michael Staszewski
> Sent: dinsdag 20 november 2012 16:29
> To: [email protected]
> Subject: RE: [toad] Formatter in TOAD for Oracle 11.6
> 
> 
> 
> Do you have the option View|Options|Files|General|"Save source files in Unix format" checked? If so try unchecking that and see if the problem is resolved. I seem to remember this coming up recently and I can no longer reproduce in the current source or in the upcoming patch build.
> 
> Michael
> 
> -----Original Message-----
> From: [email protected]<mailto:toad%40yahoogroups.com> [mailto:[email protected]<mailto:toad%40yahoogroups.com>] On Behalf Of t_rott
> Sent: Tuesday, November 20, 2012 4:50 AM
> To: [email protected]<mailto:toad%40yahoogroups.com>
> Subject: [toad] Formatter in TOAD for Oracle 11.6
> 
> Hi,
> since the version 11.6 is the function "format code" adding blank lines to the SQL.
> Code:
> SELECT B.SBA,
> 
> B.SSAP,
> 
> AR.SBEZ,
> 
> B.SARTIKEL,
> 
> A.SCHRGE
> 
> FROM BBAUF A,BARBG B left outer join ARBP AR on B.SSAP = AR.SARBPL
> 
> WHERE B.SSAP = '4800LI08'
> 
> AND B.LISTBEGINNTAG = 150804
> 
> AND B.SBA = A.SBA
> 
> If I use the old style:
> SELECT B.SBA,
> B.SSAP,
> AR.SBEZ,
> B.SARTIKEL,
> A.SCHRGE
> FROM BBAUF A, BARBG B, ARBP AR
> WHERE B.SSAP = '4800LI08'
> AND B.LISTBEGINNTAG = 150804
> AND B.SSAP = AR.SARBPL(+)
> AND B.SBA = A.SBA
> 
> everythings works perfect. It occurs just on use of LEFT OUTER JOIN and an "," in WHERE clausel.
> It worked without problems in version 11.5.
> Is there something new in the Formatter options?
> Thanks for your help
> 
> Tomas
>




------------------------------------

Yahoo! Groups Links





------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/