Cannot beautify VIEW

[braykov]

Trying to beautify a view, either from file or opened from the database for edit, fails.
It says the beautifier could not parse text.
The code looks like this:

CREATE OR REPLACE FORCE VIEW "schema_name"."V_name" ("short_name") AS
  select some_column from my_table
;

Tried also with a simpler create view statement, but it still fails with the same error.

 

[jlcox]

Either select just the query itself, or comment the first line temporarily.

 

[braykov]

Not applicable. I have a bunch of files with views that I need to format in bulk.

 

[fidelfs]

You can create a macro to go to first line and comment out the create statement, run the beautifier, go back to the first line and uncomment that line.

 

[braykov]

Everyone, please, stop suggesting complex workarounds. This is a bug and I need it fixed. There are a lot of bugs with this functionality and i have about 600 Oracle object files that need beautifying and it is not just the views.

 

[fidelfs]

I am sorry to upset you.

Beautify works for me!, I just tried to help.

Sorry!

 

[braykov]

I am not upset by you
I am actually upset by the software and by the fact that we pay money for licenses for years. And I have voted for my team to use this software and I have also influenced on using it in the previous company I worked for.
And there are bugs there standing un-fixed for years and I am not seeing any support by the developers. It looks like they are just not interested. Looks like they prefer to focus on items that are maybe easier to fix or more interesting for them, I don't know.
I am posting all these as bug reports and I expect someone to take action on them.
I know that everyone on the forum is friendly and just wants to help.

Actually your suggestion cannot work. And I will give an example. We have views that are all on one line - from the CREATE to the semicolon. Crazy, I know. And these are just because they are very short and written a long time ago. So you see if I use a macro to comment out the first line, nothing will get formatted

 

[fidelfs]

Well,

I know Marco will try to fix it.
I got used to the beautifier not working for DDL, that I created so many workaround to bypass that limitation.

I am with you, it should work for DDLs as well.
My point is how long will take Marco to fix it? We don't know.
You have a deadline to meet and you need to do something to meet it.
There is always a workaround you can use until this is fixed, otherwise your problem will continue to be a problem.

I have a simple workaround with macros for the one single line view you described as well, but I won't post it.

Keep pushing to get this fixed.

Good Luck!

 

[Marco van der Linden]

I have been using PLD for many years (if I recall correctly starting somewhere with version 5) and it has seen many improvements over time. However, the Beautifier has been lacking of improvement. With each beta of lot of suggestions/enhancement requests have been posted to the forum, (almost) none of which have made it to the release.

@Marco Kalter: Marco could you please see if you can make some time to look into improving the Beautifier instead of some spiffy new feature?
And while you're at it, column mode editing (like in UltraEdit). I know there's a (workable) plugin, but still it's not ideal.
All in all, PLD is still a great product. Keep up the good work.