Enhancement Request: Quiz and QTP

Wed Nov 21 16:09:55 CST 2007

        Hi all:

        Well it is time to eat a little crow!

        I don't know where I got the idea AND SELECT IF was doing
        an OR. I took a look at the VAX 4.01 CBT but it didn't even mention
        AND SELECT.

        The 8.4 documentation indicates that it adding selection
        to the result set already created by the CHOOSE and the SELECTs
        From the PowerHouse Quiz 8.4 Reference Manual.

         "AND SELECT [IF condition]
          Allows specification of a selection condition
          in addition to those in the SELECT IF without
          canceling the previous SELECT IF statement.

         A second AND SELECT IF overrides any previous
         AND SELECT IF statement an AND SELECT (with no conditions)

         cancels any previous AND SELECT IF statement.

         AND SELECT is another way of adding conditions; this is useful for
         adding additional selection criteria to a previously compiled report.

        Limit: This form of the SELECT statement cannot be applied to a cursor.

        The condition may reference any items that are currently accessible,
        which includes items accessed through a cursor. The condition is applied
        against the record complexes that QUIZ has built. By
        this time QUIZ has read the data."

        I say sorry to anyone tried to use an AND SELECT IF instead of an OR.

        I don't understand the Limit statement. 

        For example:-
        ACCESS *SUBFILE link  X of SUBFILE &
                                     to  Y of CURSOR        

        SELECT IF DATEZ of SUBFILE> 20060101

        AND SELECT IF LOCATON of CURSOR = 'NY'

        Is this what the documentation means when it say
           cannot be applied to a cursor.

        Or is it saying you can't include AND SELECT in a cursor.

        ; the following is incorrect syntax
          Declare XYZ cursor for select * from x_table       &
                                 and select * from y_table

Regards,
Peter

________________________________

Subject: RE: Enhancement Request: Quiz and QTP
Date: Wed, 21 Nov 2007 09:48:36 -0500
From: Bob.Deskin at cognos.com
To: robert.mills at pinnaclearvato.co.uk; powerh-l at lists.sowder.com

True, and I have kept it on the list.

By the way, I don't discard any requests. I still have stuff from the 80s. You never know when something will become feasible or reasonable. Often one thing builds on another.

Bob

________________________________

From: Robert Mills [mailto:robert.mills at pinnaclearvato.co.uk]
Sent: November 21, 2007 3:48 am
To: Deskin, Bob; powerh-l at lists.sowder.com
Subject: RE: Enhancement Request: Quiz and QTP

It's a nice-to-have not a must-have (so Bob is not wrong) but as they say, "If you don't ask for it then you'll never have a chance of getting it."

regards,

Robert W.Mills
Business Systems Development Analyst
Group Information Systems & Technology
Pinnacle Arvato
DDI: +44 (0)20 8309 3604

________________________________

From: powerh-l-bounces+robert.mills=pinnaclearvato.co.uk at lists.sowder.com [mailto:powerh-l-bounces+robert.mills=pinnaclearvato.co.uk at lists.sowder.com] On Behalf Of Deskin, Bob
Sent: 20 November 2007 19:30
To: Ken Langendock; powerh-l at lists.sowder.com
Subject: RE: Enhancement Request: Quiz and QTP

The AND SELECT in QUIZ should be ANDing the condition to the SELECT. AND SELECT is in QUIZ to add conditions to those already in use. It's there because QUIZ started out as an ad hoc report writer. The idea was that you would add the AND SELECT to refine the search. Of course you have to re-read everything anyway. I know some that people use it to split complex conditions but that wasn't the original idea. And because it's not necessarily in the same position as the SELECT, it can confuse things, as in a long report with an AND SELECT at the very end.

All that said, adding this is not necessarily complicated but in my opinion, it's not a high priority relative to many of the other things that have been requested. It's a convenience as opposed to providing new functionality. Am I wrong?

Bob

________________________________

From: powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com [mailto:powerh-l-bounces+bob.deskin=cognos.com at lists.sowder.com] On Behalf Of Ken Langendock
Sent: November 20, 2007 1:16 pm
To: powerh-l at lists.sowder.com
Subject: RE: Enhancement Request: Quiz and QTP

I have to agree with Peter on this.

I never use it....but if it is something Bob can add in without much effort, go for it.

Ken

________________________________

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 Peter Bateman
Sent: November 20, 2007 12:53 PM
To: Robert Mills; powerh-l at lists.sowder.com
Subject: RE: Enhancement Request: Quiz and QTP

        Hi Robert:

             I never liked the AND SELECT IF because it really was an OR.

             IF         ( logical expression1 ) &
                 OR    ( logical expression2 ) &
                 OR    ( logical expression3 ) &
              ...
              etc

        Regards,
        Peter

________________________________

Subject: Enhancement Request: Quiz and QTP
Date: Tue, 20 Nov 2007 15:50:43 +0000
From: robert.mills at pinnaclearvato.co.uk
To: powerh-l at lists.sowder.com

The addition of 'AND SELECT IF condition' to QTP and 'AND SELECT file IF condition' to both Quiz and QTP would make it easier to code (and understand) some of the more complex selection statements that we have to work with.

regards,

Robert W.Mills
Business Systems Development Analyst
Group Information Systems & Technology
Pinnacle Arvato
DDI: +44 (0)20 8309 3604

________________________________

R U Ready for Windows Live Messenger Beta 8.5? Try it today!

_________________________________________________________________
Send a smile, make someone laugh, have some fun! Start now!
http://www.freemessengeremoticons.ca/?icid=EMENCA122