Porblem PF/SQL Beautifier

[Uwe Schreiber]

Hi to all out there,

I run into a problem with the PS/SQL Beautifier. I'm running Version 7.0.2.1076 Language german.

The following code produces the error (translated German -> English): 'PF/SQL Beautifier could not parse text'

----------
CREATE OR REPLACE VIEW V_QC_SUB_TYPE_D_EX_BASE AS
SELECT cp.X_ACCOUNT, cp.X_PHASE, cp.ID, cp.CPTYNO, Sum(sqc.FLAGS) AS S_FLAGS, sqc.OBJECT
FROM STAMM_QUERY_CONFIG sqc, C_PORTFOLIO cp
WHERE sqc.QTYPE='D'
and sqc.PCLASS = cp.PCLASS
AND sqc.FLAG_TRADING_PORTFOLIO = cp.FLAG_TRADING_PORTFOLIO
AND sqc.FLAG_PAYABLE = cp.FLAG_PAYABLE
AND sqc.X_PHASE = cp.X_PHASE
AND sqc.X_ACCOUNT = cp.X_ACCOUNT
GROUP BY cp.X_ACCOUNT, cp.X_PHASE, cp.ID, cp.CPTYNO, sqc.OBJECT
-----------

Whats happening ?

Thanks for any help and best regards,

 

[johnsok]

Can you manually "fix" the code to get it to behave properly? If so, what did you do?

 

[William Robertson]

Select the text starting at SELECT (i.e. without the CREATE OR REPLACE VIEW line), then beautify the selection. The beautifier doesn't do DDL.

 

[Uwe Schreiber]

Thanks for the fast reply.

But are you sure? I'm not 100%, but I thought I did exactly this last week.

The error message proofs your statement, so the misstake is sitting in front of my monitor ;-)

Best regards from germany,

Uwe

 

[Stew Stryker]

Uwe,

I'm sure when I say that Beautifier don't support DDL. Trust me, I've tried! :-/