Powerhouse Enhancement - ACCESS, VIA, USING, IF

Deskin, Bob Bob.Deskin at Cognos.COM
Wed Jul 11 08:32:37 CDT 2007


Okay. I'll think on this one. As usual, no promises.
 
Bob

	-----Original Message-----
	From: Michael Lee [mailto:mcl_systems at telus.net] 
	Sent: July 9, 2007 6:37 PM
	To: Deskin, Bob
	Cc: Ken Langendock; powerh-l at lists.sowder.com
	Subject: Re: Powerhouse Enhancement - ACCESS, VIA, USING, IF
	
	
	That's a great suggestion. I've had to modify the PATH and FIND
procedure several times for just such cases. 
	
	
	Deskin, Bob wrote:
	

		Interesting idea. Can I get a feel from the list as to
how often people modify the PATH procedure? And would something like
this reduce that need? Why else do you write your own PATH procedures?
		 
		We generate the PATH and FIND based on ACCESS statements
(specified or implied) for the PRIMARY file. The two procedures are tied
together. The generation is fairly basic at this point.
		 
		Bob

			-----Original Message-----
			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: June 25, 2007 8:33 AM
			To: powerh-l at lists.sowder.com
			Subject: Powerhouse Enhancement - ACCESS, VIA,
USING, IF
			
			
			Here is a new enhancement targeted at reducing
the number of times a programmer has to hard code the PATH procedure.
			 
			FILE Users PRIMARY
			  ACCESS VIA UserId &
			       USING T-UserId &
			          IF T-UserId NE " "
			  ACCESS VIA UserId &
			       USING UserId &
			     REQUEST UserId
			  ACCESS SEQUENTIAL
			 
			 
			This new feature would generate a PATH statement
similar to the following thus removing the requirement of hard coding
the PATH every time we want to "override" the default path because of
passed-in values or re-finding based on a temporary item. etc.
			 
			PROCEDURE PATH
			BEGIN
			  IF T-UserId NE " "
			     THEN LET PATH = 1
			  IF PATH = 0
			     THEN PROMPT T-UserId
			...
			END
			 
			 
			Ken
			 
			 
			  
			 

		 
		     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. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20070711/f62dc84e/attachment.html


More information about the powerh-l mailing list