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_FA KTURE C08
,rownum C00
,PFA.SIFRA_POZI CIJE C01
,PFA.OPIS C05
,PFA.KOLICINA C03
,PFA.FOR_ENME_E NOTA C02
,to_char(PFA.CE NA,decode(sign( PFA.CENA-10000),'-1','9999.99','9 99999')) C04
,TO_CHAR(PFA.VR EDNOST,'9999999 9.99') C06
,PFA.PRIPDA_DFA _SIFRA C07
FROM POZICIJE_FAKTUR PFA
WHERE PFA.FKT_STEVILK A_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]

Re: Blank line Inserted - I don't like it


SET RECSEP OFF



;)



PS: What is COLUMN CLEAR?




--
Posted via http://dbforums.com

[Miran Kopmajer]

Re: Blank line Inserted - I don't like it

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

[LKBrwn_DBA]

Re: Blank line Inserted - I don't like it


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