FW: Item Listing in Quiz

Guy Werry guy.werry at hbms.ca
Tue Feb 5 14:30:40 CST 2008


I'm forwarding Ken's response, as it looks like he only sent it to me.
This looks like it could work (I did NOT try it); furthermore, a person
should be able to take the output from QSHOW and manipulate it to come
up with something like this.

Guy L. Werry
Senior Systems Analyst
Hudson Bay Mining & Smelting Co., Limited.  

-----Original Message-----
From: Ken Langendock [mailto:Ken at Langendock.com] 
Sent: Tuesday, February 05, 2008 2:14 PM
To: Guy Werry
Subject: RE: Item Listing in Quiz

Couldn't you just put a skip 1 tab 1 before each field and replicate the
field name into a title?

set page length 0
report &
skip 1 tab 1 "Field1" Field1 &
skip 1 tab 1 "Field2" Field2 &
skip 1 tab 1 "Field3" Field3 

A little tedious, but should work.

-----Original Message-----
From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of Guy Werry
Sent: February 5, 2008 2:44 PM
To: powerh-l at lists.sowder.com
Subject: RE: Item Listing in Quiz

REPORT ALL in Query sounds like the most logical thing.  Perhaps
something with Suprtool?
If you were to do it in Quiz you would have to force a line feed after
each field.  We use Unix and I'm sure that you could set the report line
up so that a line feed (carriage return) could be hard-coded after each
field, but you'd wind up with problems very quickly with the page width.

Thinking about this, it was almost certainly a different tool.  I did
something like this recently using SQL and Oracle and it was a
NIGHTMARE.

Guy L. Werry
Senior Systems Analyst
Hudson Bay Mining & Smelting Co., Limited. 

-----Original Message-----
From: powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com
[mailto:powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com] On Behalf
Of Johnson, Tracy
Sent: Tuesday, February 05, 2008 1:29 PM
To: John Stires; powerh-l at lists.sowder.com
Subject: RE: Item Listing in Quiz

Fifty/Fifty of one of the two below:

She was probably using QUICK (ala QDESIGN) followed by a GO and not
Quiz. 

Otherwise she was probably in QUERY using a REPORT ALL after a FIND.  

(REPORT ALL in QUERY seems similar to Quiz doesn't' it?)

> -----Original Message-----
> From: 
> powerh-l-bounces+tracy.johnson=meas-spec.com at lists.sowder.com
> [mailto:powerh-l-bounces+tracy.johnson=meas-spec.com at lists.sow
> der.com] On Behalf Of John Stires
> Sent: Tuesday, February 05, 2008 2:23 PM
> To: powerh-l at lists.sowder.com
> Subject: Item Listing in Quiz
> 
> I just had a meeting with my manager who had an interesting request.  
> She had someone working for her a while back that had a way, in QUIZ, 
> of listing the field name with the contents of that field immediately 
> after the item name on the same line; like a verical listing.  She is 
> looking to avoid records with lots of fields wrapping aroung and 
> missing the field names that go with the data.  This guy told her that

> this was a function within PowerHouse.  It turned out looking 
> something like this:
>  
> Branch_ID    01
> Location        Chicago
> Type              Sales
> Branch_ID    02
> Location        St. Louis
> Type              Sales Support
>  
> I played around with it a bit, but could not find anything that would 
> even come close accomplishing this.  I could write a .COM file that 
> might do the trick by capturing the fields from a QSHOW listing, but 
> she says that it was supposedly all within PowerHouse.  We are running

> 7.10.G1 on OpenVMS 8.3.
>  
> Can anyone out there offer me some help?
>  
> Thanks,
> pencarver
> John Stires
> 

-- 

= = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.

The information in this e-mail and any attachments is confidential and
may be subject to legal professional privilege. It is intended solely
for the attention and use of the named addressee(s). If you are not the
intended recipient, or person responsible for delivering this
information to the intended recipient, please notify the sender
immediately. Unless you are the intended recipient or his/her
representative you are not authorised to, and must not, read, copy,
distribute, use or retain this message or any part of it.

--

powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.


The information in this e-mail and any attachments is confidential and may be subject to legal professional privilege. It is intended solely for the attention and use of the named addressee(s). If you are not the intended recipient, or person responsible for delivering this information to the intended recipient, please notify the sender immediately. Unless you are the intended recipient or his/her representative you are not authorised to, and must not, read, copy, distribute, use or retain this message or any part of it.



More information about the powerh-l mailing list