Quiz Reporting Errors

[Bob Benson]

LOL!  Gee Matt, when is the memorial service?  We all want to come but we
will probably be working on our latest Powerhouse PC improvements.  (I'm
just trying to see if we can shake loose some more reminiscing from the ole
guy before he passes on to that great big data conversion error we all
eventually must face).

Bob Benson

----------
> From: MattO1@aol.com
> To: powerh-l@lists.swau.edu
> Subject: Re: Quiz Reporting Errors
> Date: Friday, February 19, 1999 3:38 PM
> 
> In a message dated 2/19/99 9:55:37 AM EST, John Pickering writes:
> 
> << Between Quiz 4.00 and Quiz 5.01, Cognos changed the assumed file for
an   
>  unqualified item from the last file in the access statement containing  

>  the item to the first file. This caught a lot of lazy programmers (the  

>  kind who never qualify anything) and resulted in report programs which
no   
>  longer worked.
>   >>
> Interesting you mention that.  You are right, some programs did stop
working,
> but usually QTP, not Quiz (although it is possible they gave incorrect
answers
> <grin>). 
> 
> The most distinctive change I remember in going to 5.01 is that most
reports
> ran *much* faster!  The difference seemed to be that in SELECT statements
> under the 4.00  the *last* occurrence of an unqualified item in the list
of
> files in the ACCESS statement would be selected.  For example, if an item
> appeared in the 1st and the 5th file in the ACCESS statement, then 4.00
Quiz
> would have to read records from all 5 files before rejecting the record
> complex.
> 
> With 5.01, Quiz selected the *first* item found.  Using the example
above,
> Quiz 5.01 would only read one record then immediately reject the record
> complex.
> 
> I recall distinctive discovering this when a client asked me why his
program
> ran so slow on his terminal and so *fast* on mine! ;-)  It turned out I
had my
> UDC set to point at 5.01 and his was still pointing at 4.00.
> 
> No great earth-shattering information here, just an old PH coot
reminiscing
> ;-)
> 
> Matt Ohmes
> Matt.Ohmes@Cognos
> MattO1@AOL.COM  (that's 'oh' 1 not "zero" 1) 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
=
> Subscribe: "subscribe powerh-l" in message body to
majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to
majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.