Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!pacific.mps.ohio-state.edu!linac!att!cbnewsm!hpp
From: hpp@cbnewsm.att.com (hariharan.p.panamanna)
Newsgroups: comp.databases
Subject: Re: Printing query results in SQLFORMS
Message-ID: <1991May9.185911.22056@cbnewsm.att.com>
Date: 9 May 91 18:59:11 GMT
References: <1991May8.180418.14287@news.iastate.edu>
Distribution: usa
Organization: AT&T Bell Laboratories
Lines: 16

In article <1991May8.180418.14287@news.iastate.edu>, S1.SRE@isumvs.iastate.edu (Sree) writes:
> Does anyone know how to produce a printout of the results obtained
> from an EXEQUERY function in SQLFORMS? We run Oracle 5.1b and
> SQLFORMS 2.x. The key assignment for printing does not work for
> the IBM PS/2 models. When this question was posed to Oracle, a
> year or two ago, they did not have any solutions. I doubt they
> have a solution even now! May be some of you have a solution.The
> problem exists even in 5.1c.

	You can redefine the KEY-PRINT to  HOST call a sql script 
which will fetch those records, which are displayed on the form.
You can direct the outout to the printer or to file.
The overhead is writing the SQL script.

Hari
cbnewsm!att!com!hpp