Formatter in TOAD for Oracle 11.6

[t_rott]

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:
toad-***@yahoogroups.com
toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

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

[Tryon, Christopher S]

I've noticed the same. If I kept formatting, more lines are added. I eventually did something and it formatted normally.

Chris

From: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of t_rott
Sent: Tuesday, November 20, 2012 4:50 AM
To: ***@yahoogroups.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


______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________

______________________________________________________________________
Attention:
This e-mail and any files transmitted with it from Hatch Mott MacDonald are confidential and intended solely for use of the individual or entity to whom they are addressed. If you have received this e-mail in error please immediately notify the sender.
______________________________________________________________________

[Michael Staszewski]

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: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of t_rott
Sent: Tuesday, November 20, 2012 4:50 AM
To: ***@yahoogroups.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:
toad-***@yahoogroups.com
toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

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

[Andre Vergison]

It’s a bug in the formatter due to recent changes to join formatting. I’ll look into this.

Andre

________________________________
From: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of Michael Staszewski
Sent: dinsdag 20 november 2012 16:29
To: ***@yahoogroups.com
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: ***@yahoogroups.com<mailto:toad%40yahoogroups.com> [mailto:***@yahoogroups.com<mailto:toad%40yahoogroups.com>] On Behalf Of t_rott
Sent: Tuesday, November 20, 2012 4:50 AM
To: ***@yahoogroups.com<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

[Andre Vergison]

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: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of Andre Vergison
Sent: dinsdag 20 november 2012 17:07
To: ***@yahoogroups.com
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: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of Michael Staszewski
Sent: dinsdag 20 november 2012 16:29
To: ***@yahoogroups.com
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: ***@yahoogroups.com<mailto:toad%40yahoogroups.com> [mailto:***@yahoogroups.com<mailto:toad%40yahoogroups.com>] On Behalf Of t_rott
Sent: Tuesday, November 20, 2012 4:50 AM
To: ***@yahoogroups.com<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

[t_rott]

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

Tomas

Post by Andre Vergison
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
________________________________
Sent: dinsdag 20 november 2012 17:07
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
________________________________
Sent: dinsdag 20 november 2012 16:29
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-----
Sent: Tuesday, November 20, 2012 4:50 AM
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.
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
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:
toad-***@yahoogroups.com
toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

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

[Brad Boddicker]

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: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of t_rott
Sent: Wednesday, November 21, 2012 4:34 AM
To: ***@yahoogroups.com
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

Post by Andre Vergison
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
________________________________
Sent: dinsdag 20 november 2012 17:07
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
________________________________
Sent: dinsdag 20 november 2012 16:29
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-----
Sent: Tuesday, November 20, 2012 4:50 AM
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.
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
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:
toad-***@yahoogroups.com
toad-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
toad-***@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:

[MCALLISTER, MICHAEL CTR AETC AETC/A3IS]

I had this issue and logged a support case on it. It is a known issue with the
formatting module, however the version of the formatting module that is in the
beta already addresses this issue. So - next release should solve the problem.

Regards,

Mike McAllister
Principal Systems Engineer
Decypher
DSN: 487-3751
Commercial: [phone]
Cell: [phone]
Email: ***@us.af.mil

-----Original Message-----
From: ***@yahoogroups.com [mailto:***@yahoogroups.com] On Behalf Of t_rott
Sent: Tuesday, November 20, 2012 3:50 AM
To: ***@yahoogroups.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