Item Listing in Quiz

[John Backus]

John Stires wrote:
> 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,
>   
:Hello Quiz and Qtp Users,

At www.beechglen.com, under 'MPE/iX' and then  under 'HPe3000 Freeware 
and Downloads' can be found among other useful things, 'Powerhouse 
Developer Tools'.*//*

One set of tools creates Query like listings of any files available to 
Quiz's access statement.  The other set creates Quiz or Qtp code to give 
one a head start
on report or subfile creation as well as in creating code that can be 
used to generate delimited ASCII files.  Note:  This code pre-dated the 
PORTABLE option.

In each toolset there is a 5.06, 7.09 and a 7.29 version where the newer 
versions added functionality.  I think that the 7.29 version works under 
Quiz 8.?? too, but if not, the code should be easily modified to make it 
work.  Each code 'step' is documented fairly well--so says me :) ,and 
the whole is driven by the primary input data which is the output of a 
Quiz "show items" statement.

Shortcomings in readability, etc. are hopefully outweighed by these 
great features:  it is free, safe and it works. 

Be sure to read the comments that are made in the beginning section of 
the code and make any simple adjustments or setup as described there.

To get these tools, just copy and paste the source code into your 
favorite editor.  Please note though, that if EDITOR.PUB.SYS is used, 
Editor has problems with the '&' (continuation) character as it 'eats' 
them on the paste side.  If Editor is all that one has, then as a 
workaround, copy & paste into a Microsoft Word document and then change 
the '&' to a placeholder like a '%%' (double percent) characters, as an 
intermediate step.  Then, when the file has been uploaded to the 3000, 
just edit the file to change '%%' to '&'.

For example:

:run editor.pub.sys
add
<paste>
press return
//
change "%%" to "&" in all
keep qzez729,unn
exit

I hope that some find these tools useful.  I certainly enjoyed 
developing them and using them.

Courtesy of Beechglen Development, Inc.

John Backus
Beechglen Support Team
support at beechglen.com  [Attention:  John]
(513) 922-0509 x27