RE: Formatter in TOAD for Oracle 11.6

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