Can it work using Quick ? Works with quiz.

[Deskin, Bob]

That's my understanding as well. The SELECT applies to record retrieval
regardless of the number of ACCESS statements and regardless of where
the SELECT is placed in relation to those ACCESS statements. In fact, if
you have multiple SELECT statements, they're supposed to be ANDed
together, again regardless of position. This applies on MPE/iX, OpenVMS,
UNIX, and Windows. I don't know for sure about AS/400.

Of course, if anyone has a test case to prove us wrong ...

Bob Deskin              
Senior Product Manager, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA 

-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Pickering, John
(NORBORD)
Sent: November 15, 2004 3:33 PM
To: 'David Morrison - Corporate'; powerh-l@lists.sowder.com
Subject: RE: Can it work using Quick ? Works with quiz.


David Morrison wrote ...

>If so, make sure you put the SELECT before
>the ACCESS, so that if you have multiple
>ACCESS statements (paths), the SELECT
>will apply to all of them.

Huh???

It has always been my understanding and experience that the SELECT
statement applies to the records retrieved regardless of which PATH
(i.e. ACCESS
statement) is used. So it shouldn't matter if the SELECT statement is
before the ACCESS statement(s) or after. Basically they are independent
statements.

I'd encourage you to pick either before or after and always use code it
that way but that's just for style and in the interests of making the
life of the poor guy who comes after you easier.

But I've been wrong on occasion!

Regards,
JWP

-----Original Message-----
From: David Morrison - Corporate [mailto:dmorrison@mcbrideelectric.com]
Sent: Monday, November 15, 2004 3:04 PM
To: Yvonne Erkes; powerh-l@lists.sowder.com
Subject: RE: Can it work using Quick ? Works with quiz.


Yvonne,

Have you tried something like:

FILE customer
SELECT customer IF account_balance > credit_limit
ACCESS customer ...

If so, make sure you put the SELECT before the ACCESS, so that if you
have multiple ACCESS statements (paths), the SELECT will apply to all of
them.

Thanks.

David Morrison
McBride Electric

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@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. 
  
       This message may contain privileged and/or confidential information.  If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so.  Thank you.