Blank line Inserted - I don't like it

[Miran Kopmajer]

I have a problem with blank line inserted. Please help!
This is how my SQL report looks like

ACCEPT vf CHAR PROMPT "Vrsta fakture: "
ACCEPT fk CHAR PROMPT "Faktura: "

SET PAGES 72
set NEWPAGE 1
SET VERIFY OFF
SET TERMOUT OFF
set space 1

SET LINESIZE 80
CLEAR BREAKS COMPUTES

COL C00 FORMAT 999 HEADING 'POZ'
COL C01 FORMAT A7 HEADING 'Sifra' TRUNC
COL C02 FORMAT A3 HEADING 'EM' TRUNC
COL C03 FORMAT 99999.99 HEADING 'Kolicina'
COL C04 FORMAT A9 HEADING 'Cena'
COL C05 FORMAT A20 HEADING 'Ime blaga' word_wrap
COL C06 FORMAT A12 HEADING 'Znesek'
COL C07 FORMAT A3 HEADING 'Rab' TRUNC
COL C08 FORMAT 99 HEADING 'P'

CLEAR BREAKS COMPUTES

COLUMN CLEAR

SPOOL FK02.lis

SELECT PFA.POZICIJA_FAKTURE C08
,rownum C00
,PFA.SIFRA_POZICIJE C01
,PFA.OPIS C05
,PFA.KOLICINA C03
,PFA.FOR_ENME_ENOTA C02
,to_char(PFA.CENA,decode(sign(PFA.CENA-10000),'-1','9999.99','999999')) C04
,TO_CHAR(PFA.VREDNOST,'99999999.99') C06
,PFA.PRIPDA_DFA_SIFRA C07
FROM POZICIJE_FAKTUR PFA
WHERE PFA.FKT_STEVILKA_RACUNA = '&fk'
AND PFA.vrsta = '&vf';

SPOOL OFF

HOST qprt -P lp4:lp4 FK02.lis

EXIT
and returns:

1 1 0300205 ALU-RAVNILO 100CM,Z 200.00 788.95
MM-SKALO BRE
(*)
2 2 0300102 ALU RAVN.S SK 1500.00 593.07
50CM,Z ROČ.

Can you help me, why that blank line (*) is inserted.

I 'd report like this
1 1 0300205 ALU-RAVNILO 100CM,Z 200.00 788.95
MM-SKALO BRE
2 2 0300102 ALU RAVN.S SK 1500.00 593.07
50CM,Z ROČ.
Thank you very much.

[LKBrwn_DBA]

SET RECSEP OFF

;)

PS: What is COLUMN CLEAR?


--
Posted via http://dbforums.com

[Miran Kopmajer]

With COLUMN CLEAR I wanted to clear all column definitions.
Must be remarked.
Thx,M

[LKBrwn_DBA]

TO clear all column definitions use:

CLEAR COL

But watch out!!!, you have positioned this statement BEFORE your
report...

Set the statement before the col ... for ... definitions (and/or after
the report).

:cool:
--
Posted via http://dbforums.com