Can it work using Quick ? Works with quiz.

[David Morrison - Corporate]

John,

This may be an AS/400 circumstance, only, or maybe I'm mistaken, but it seemed to fix a problem I had one time, so I stuck with it.

Thanks.

David Morrison

-----Original Message-----
From: Pickering, John (NORBORD) [mailto:John.Pickering@norbord.com]
Sent: Monday, November 15, 2004 12: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