Can it work using Quick ? Works with quiz.

[David Morrison - Corporate]

Guy,

I don't know if that was the problem, or not.

We try to always specify the file names, to eliminate any possibility of confusion on PH's part.  But, sometimes it accidentally gets skipped.

Thanks.

David

-----Original Message-----
From: Guy Werry [mailto:guy.werry@hbms.ca]
Sent: Monday, November 15, 2004 12:57 PM
To: David Morrison - Corporate; Pickering, John (NORBORD);
powerh-l@lists.sowder.com
Subject: RE: Can it work using Quick ? Works with quiz.


David,

I've never worked on the AS/400, but this sounds to me like one of those
buffer conflicts that can pop up.  If you have data items in two or more
files that have the same names, then there can be cases where Quick gets the
two of them confused, EVEN if you have a SET ASSUMED statement.

We usually put the SELECTs at the end of the ACCESS statements and it
doesn't cause any problems, although we've always been on HP (both MPE and
Ux).

Guy L. Werry
Senior Systems Analyst
Hudson Bay Mining & Smelting Co., Limited. 

-----Original Message-----
From: David Morrison - Corporate [mailto:dmorrison@mcbrideelectric.com]
Sent: Monday, November 15, 2004 2:29 PM
To: Pickering, John (NORBORD); powerh-l@lists.sowder.com
Subject: RE: Can it work using Quick ? Works with quiz.


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


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.