Hi
I’ve just applied the Toad 6.0.1 64 bit patch and it has broken the Formatter for me. All formatting I do is now picking up the default settings - which aren’t our company standard.
If I go into the Formatter settings, it still shows the correct settings and gives me the correct format in the preview window, but formatting in the standard editor windows doesn’t. It does however still put in the correct header text at the top.
Thanks
Dan
I have also experienced the same issue. Quite annoying!
Hello,
I’m trying to reproduce this issue and I haven’t had any luck. I’ve tried at least 1 setting from each formatting category. I confirmed the settings were
turned on and worked. After I restarted Toad the settings are sticking fine and continue to work. Can you tell me specifically which settings are not sticking?
Thanks,
Brad
From: DanCJ [mailto:bounce-DanCJ@toadworld.com]
Sent: Monday, August 05, 2013 6:43 AM
Subject: [Toad for Oracle - Discussion Forum] Toad 12.0.1 breaks Formatter
Thread created by DanCJ
Hi
I’ve just applied the Toad 6.0.1 64 bit patch and it has broken the Formatter for me. All formatting I do is now picking up the default settings - which aren’t our company standard.
If I go into the Formatter settings, it still shows the correct settings and gives me the correct format in the preview window, but formatting in the standard editor windows doesn’t. It does
however still put in the correct header text at the top.
Thanks
Dan
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
The ones I’ve noticed so far are:
We have all of our code in lower-case, but the formatter is putting it in capitals.
In our select clauses we have the commas at the beginning of each line, but they are appearing at the end.
We have a space inside the parentheses which is not being put in (eg: we get “NUMBER(10)” instead of “number( 10 )”).
Thanks
Dan
Wow, coincidentally, these are the exact 3 options that I tried and saw no problems with them.
If you go to options > Formatter. You will see the location of your FmtPLus.opt file Toad is using at the top. Does this look correct to you? For me, it
points to the one in my current 12.0 user files
From: DanCJ [mailto:bounce-DanCJ@toadworld.com]
Sent: Monday, August 05, 2013 10:45 AM
Subject: RE: [Toad for Oracle - Discussion Forum] Toad 12.0.1 breaks Formatter
RE: Toad 12.0.1 breaks Formatter
Reply by DanCJ
The ones I’ve noticed so far are:
We have all of our code in lower-case, but the formatter is putting it in capitals.
In our select clauses we have the commas at the beginning of each line, but they are appearing at the end.
We have a space inside the parentheses which is not being put in (eg: we get “number(10)” instead of “number( 10 )”).
Thanks
Dan
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
Yes - My path is C:\Users\dcondo\AppData\Roaming\Quest Software\Toad for Oracle\12.0\User Files.
I’m happy to email you a copy of my FmtPlus.opt file if you like.
I’ve stuck it on Dropbox - here’s a link: www.dropbox.com/…/FmtPlus.opt
Thanks. I’ll get back to you
From: DanCJ [mailto:bounce-DanCJ@toadworld.com]
Sent: Monday, August 05, 2013 11:29 AM
Subject: RE: [Toad for Oracle - Discussion Forum] Toad 12.0.1 breaks Formatter
RE: Toad 12.0.1 breaks Formatter
Reply by DanCJ
I’ve stuck it on Dropbox - here’s a link:
www.dropbox.com/…/FmtPlus.opt
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
I can reproduce this issue with your file. I’m passing this on to a developer now. Someone will be in touch soon
From: DanCJ [mailto:bounce-DanCJ@toadworld.com]
Sent: Monday, August 05, 2013 11:29 AM
Subject: RE: [Toad for Oracle - Discussion Forum] Toad 12.0.1 breaks Formatter
RE: Toad 12.0.1 breaks Formatter
Reply by DanCJ
I’ve stuck it on Dropbox - here’s a link:
www.dropbox.com/…/FmtPlus.opt
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
Great - Thanks!
Should be fixed in tomorrow’s beta.
I just did the file edit you mentioned in the other post rather than installing the beta - and that’s worked a treat.
Thanks a lot!
Nice to hear. But only today’s next beta containing qp5.dll version 5.256 will take over the workaround.