Re: Developer 2000 SQL*Plus printing

From: Jamie Keir <jkerr_at_jameswatt.ac.uk>
Date: 1997/07/16
Message-ID: <33CC8C5E.38C01491@jameswatt.ac.uk>#1/1

Mr. Chow Wing Siu wrote:
>
> Hi, I have Windows 95 and developer 2000. When I use SQL*Plus to
> print, it does not have default network printer or I do not know
> how to set the network printer. How to do it as if it were in UNIX?
>

I've got round this, but it's *very* messy. If there's another way, I'd be interested too.

Spool the output to a disk file, then print that file to the default PC printer, ie.

SQL> spool temp.txt
SQL> <insert query here>
SQL> spool off
SQL> exit
C:\> TYPE >PRN: temp.txt

Of course you can do this within Forms4.5 using HOST commands.

Jamie Keir

Incidentally, would anyone like to be able to print directly from a Forms 4.5 block, using nothing more than a couple of triggers and a table? Received on Wed Jul 16 1997 - 00:00:00 CDT