Item Listing in Quiz

[Peter Bateman]

Hi John:
 
 
     If you are using a relation database as your data source
     you can create a simple dump of a table by creating QUIZ
     source from the metadata. 
     If you are using IMAGE you can build the metadata by using IMAGESQL
     You would attach to the ALLBASE database populated by IMAGESQL.
     
     For Oracle/RDB it goes something like:-
 
QUIZ 
; Quiz code to create a QUIZ program from metadata
; You could also test if a field is character and put a WRAP option
; on generated report item.
;   
    Access RDB$RELATION_FIELDS in DB alias RF
    Choose RDB$RELATION_NAME parm
    Initial heading &
     "ACCESS " RDB$RELATION_NAME of RF "IN DB ALIAS  X" Skip 1 &
     "REPORT &" 
    Report &
   '"' RDB$FIELD_NAME  of RF '"'  RDB$FIELD_NAME of RF  "OF X  SKIP 1 &"
   Set nohead 
   Set report device disc name DUMPTABLE
   set page length 0
 go
 
 
QUIZ
   USE DUMPTABLE.txt
 
Regards,
Peter Bateman
 
 
etc 
> Date: Tue, 5 Feb 2008 23:18:39 -0500> From: john at beechglen.com> To: pencarver at sbcglobal.net> Subject: Re: Item Listing in Quiz> CC: powerh-l at lists.sowder.com> > 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> > -- > = = = = = = = = = = = = = = = = = = = = = = = = = = = => Mailing list: powerh-l at lists.sowder.com> Subscribe: &quot;subscribe&quot; in message body to powerh-l-request at lists.sowder.com> Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; 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.
_________________________________________________________________

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20080206/78f8c8ca/attachment.htm