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

<*> 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/