Toad World® Forums

empty line when formatting a model with no rules keyword

Hi !

The “RULES” keyword is mandatory if you iterate otherwise it is optional. Plain SELECT statements shall not have blank lines.

DEMO:

select*from dual model dimension by(1 x)measures(1 y)rules(y[2]=314);

formats well but …

select*from dual model dimension by(1 x)measures(1 y)(y[2]=314);

Generates an empty line

/* Formatted on 24/06/2013 13:25:45 (QP5 v5.252.13127.32847) */
SELECT *
FROM DUAL
MODEL
DIMENSION BY (1 x)
MEASURES (1 y)

(y [2] = 314);

I have posted the question per email a few weeks ago too, sorry for multiposting. It probably ended up in some spam folder…

I’m still working on this one. The model clause is fairly complex and the “generalized” fix takes a bit of time …

Andre