To Quiz or not to Quiz...

[brian_matthewsbrian matthews]

ah yes, this is what I was thinking of ( excluding keep will be generate a 
temp dict only ).

Quiz will provide formatted data only to a report file without the summary 
option.  A subfile will give you what you want but you have to put in some 
work. Sadly, 7.10.E does not have the formatnumber option so you will have 
to format numerics yourself using techniques like that below,

for a quiz reported numeric item such as 999,999.99 you will have to code as 
below for all numeric types using defines for each,

e.g. data item nett_price and assuming a integer type with input scale two 
and 2 decimal places,

define d_nett_price char *10 = &
ascii ( floor (nett_price /100000 ) ) + "," + &
ascii ( mod(floor (nett_price /100 ), 1000 ) ,3 ) + "." + &
ascii ( mod (nett_price , 100 ),2 )

this is from memory only and without access to quiz, so I would be 
astonished if there were no errors :)

regards Bri,




>From: "Al Karman" <Alk at liasophia.com>
>To: <Tremblay.Pierre-McLeod at hydro.qc.ca>, <powerh-l at lists.sowder.com>
>Subject: RE: To Quiz or not to Quiz...
>Date: Thu, 9 Jun 2005 16:24:45 -0500
>
>Pierre,
>
>
>
>Try writing output to a subfile instead of a disc file.using the
>NODICTIONARY option.
>
>
>
>
>
>Al
>
>
>Al Karman
>Director of Information Technology
>lia sophia
>  <mailto:alk at liasophia.com> alk at liasophia.com
>
>
>   _____
>
>From: powerh-l-bounces+alk=liasophia.com at lists.sowder.com
>[mailto:powerh-l-bounces+alk=liasophia.com at lists.sowder.com] On Behalf Of
>Tremblay.Pierre-McLeod at hydro.qc.ca
>Sent: Thursday, June 09, 2005 4:14 PM
>To: powerh-l at lists.sowder.com
>Subject: To Quiz or not to Quiz...
>
>
>
>Hi everybody,
>
>I'm trying to extract powerhouse data to an ASCII file keeping the correct
>dictionary picture format.
>
>Using Quiz, everything is OK, it's like a report, so the numbers are
>formatted according to the dictionary format without having to specify a
>picture for every field.  Good!   But, I cannot exceed the 263 characters
>barrier for a record.  It wraps the line. ...  hum...  too bad...
>
>Using QTP, I don't have the wraparound problem but the format of the fields
>is catastrophic.  Presented as they are stored on file, without any decimal
>format, the numbers are useless.
>
>There is certainly a way to create records more than 263 characters long in
>Quiz or to use the dictionary format in QTP ?
>
>Surely I'm missing something.... ?
>
>I'm talking about powerhouse 7.10.E sitting on a vax computer running
>OpenVMS 6.2
>
>Thank's !
>
>Best regards.
>
>
>Pierre McLeod Tremblay
>Consultant T.I. / I.T. Consultant
>pmcleod at videotron.ca
>819.263.0791 fax: 819.263.0792
>My french is better than my english.  Sorry for the Frenglish...
>
>--
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l at lists.sowder.com
>Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
>Unsubscribe: "unsubscribe &lt;password&gt;" 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.

_________________________________________________________________
Be the first to hear what's new at MSN - sign up to our free newsletters! 
http://www.msn.co.uk/newsletters