Re: SqlPlus report keeps outputting the SQL statement

"news.kolumbus.fi" <Jaakko.Terhonen_at_kolumbus.fi> wrote in message news:<9m3doe$mrk$1_at_news.kolumbus.fi>...
>
> Thank You, Thomas, but I already have those settings. Sorry Steve, I know
> You ment well...
 ok, we had to thought so :-)
>
> There's something weird in this. I created a quick-and-dirty version of my
> report which reads EMP and DEPT tables and managed to get it to behave
> equally.

see in source ... ok it's really hard to find :-)

> If anyone wishes to test this in his/hers own environment and see what is
> happening, here it is:
 .... cut all the stuff
>
> tti left h_company -
> col 32 'TEST LIST' col 76 sql.pno format 999 -
> skip 'TESTREP.sql' col 32 h_CurrDate -
> skip 2 -
> left h_departure -
> skip 2 'Count:' h_MENCOUNT ' men,' h_womencount ' women, total of '
> h_allcount skip 2
 this ; is too much :-) your first query is executed here again
> ;

the rest is all fine

Hth
Thomas Received on Fri Aug 24 2001 - 09:00:19 CEST