displaying data to screen

[Terry Curran]

It woul be helpful if people are asking for assistance with PowerHouse if
they quoted the PowerHouse version and operating system, as then replies
could be formulated for the specific query!!!

-----Original Message-----
From: powerh-l-admin@cube.swau.edu
[mailto:powerh-l-admin@cube.swau.edu]On Behalf Of Merol Newman
Sent: 23 August 2002 20:39
To: stonecold99@hotmail.com
Cc: powerh-l@lists.swau.edu
Subject: RE: displaying data to screen


Hello Scott

If this is what you meant (John's reply), unless your record is very small,
you
also need

>set nohead

Otherwise your screen will contain all headings and hardly any data. And if
you
want to look at more than 100 records, you also need

>set report limit n	;where n is max no you want to display

or
>set report nolimit	;not valid if HP MPE

Sometimes it's easier to look at the data one record at a time. To do this,
with
default labels included, use qdesign to build a very simple screen:-

>screen <anyname>
>file <yourfile> [in <yourdatabase>]
>generate
>build	;optional - saves as compiled screen
>go

If it says the screen limit has been exceeded, you'll have to edit the
source
code it has produced:-

>save <anyname> 	;this saves the source, not the compiled screen

edit anyname.qks (or vi or whatever)
(rearrange layout to squeeze it all in, or remove some lines, or split some
off
into a slave screen). Then recompile:-

qdesign
>use anyname
>go

next time, run the compiled version anyname.qkc:-

quick auto=anyname

Abject apologies if you're not such a newbie as you make out! I thought at
first
maybe you wanted to display the results of a query in SQL used as a cursor.
If
so, the code for declaring the cursor would replace the ACCESS or FILE
statements above, but apart from that it should work the same way.

Have a good weekend, all you people over the ocean who are still at work!

bye
Merol


merol.newman@ramesys.com
Ramesys, Eldon Way, Crick, Northamptonshire, UK. NN6 7SL
phone 01788 822133/823831, fax 01788 823601


-----Original Message-----
From: powerh-l-admin@cube.swau.edu
[mailto:powerh-l-admin@cube.swau.edu]On Behalf Of Pickering, John
(NORBORD)
Sent: 23 August 2002 18:27
To: 'scott wagler';
Subject: RE: displaying data to screen


How about:

QUIZ
>access your_file
>report all
>set report device terminal
>go

Actually the 'set report device terminal' is the defualt so you don't really
need it.

> -----Original Message-----
> From:	scott wagler [SMTP:stonecold99@hotmail.com]
> Sent:	Friday, August 23, 2002 12:54 PM
> To:	powerh-l@lists.swau.edu
> Subject:	displaying data to screen
>
> hi,
>
> i'm a newbie to powerhouse and have a very simple question.  i am trying
> to
> display the results of a query to the screen to make sure that the query
> returns what i want.
>
> what command would i use to do this, thanks.
>
> scott.
>

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.