Re: SqlPlus report keeps outputting the SQL statement

Yes! You're the MAN, Thomas! Thanks a lot!

rgds,

    Jaakko.

"T. Schwickert" <schwickert_at_yahoo.com> kirjoitti viestissä news:5fcc15a8.0108232300.2d11ac6d_at_posting.google.com...
> "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 - 11:30:34 CEST