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

Printing SQL Queries? (AREV Specific)

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
  1. 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]

www.sprezzatura.com_zz.jpg

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...