Printing SQL Queries? (AREV Specific) [Revelation On-Line Wiki]

AREV Specific

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 23 FEB 2000 09:39:59AM Jim Horvath wrote:

A simple question (I hope)

From TCL, (AREV version 3.03) how do you print the results of an SQL query? For example on my system the following query outputs correctly to the screen:
 sql select * from opr.master
but when I try to send it to the printer by appending (p), I get:
      There is an undetermined syntax error
or-

there are invalid characters following the statement.

What's the correct syntax?

TIA

Jim

At 24 FEB 2000 10:44PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:

Try
sql select * from opr.master to printer
The Sprezzatura Group

[/i]World leaders in all things RevSoft[/i]

At 25 FEB 2000 01:33PM Jim Horvath wrote:

TO PRINTER !!!!

That was it, of course. Thanks.

As I write this, I am sitting with the AREV version 3.0 manuals and even knowing the answer, I can find nothing in them about the TO PRINTER clause of an SQL statement.

Of course I could have just R/List'ed that table to the printer, but for more complicated ad-hoc queries I prefer SQL, so I appreciate being able to print the results.

Thanks again,

Jim

View this thread on the forum...