Stupid question about Primary and Secondary

[Peter Bateman]

        Hi Fernando:
 
              You can modify FIND Procedure
               and remove the OPTIONAL clause on the SECONDARY file.
  
              Or in 
                    Procedure  POSTFIND 
                    BEGIN
                        IF NOT ACCESSOK 
                             THEN PUSH NEXT ; I am not exactly certain of this syntax
                                                       ; The idea is to get the next primary record
                     END
 
        Regards,
        Peter Bateman
               
 


From: fernando.olmos at hpa.com.auTo: powerh-l at lists.sowder.comSubject: Stupid question about Primary and SecondaryDate: Wed, 14 Nov 2007 11:27:34 +1100

I thought that the following code would make the ORDER_MASTER table *not* optional! 
> screen ert > file customers in isdb > file order_master in isdb secondary > build list detail 
> PROCEDURE PATH >   BEGIN >     LET PATH = 1 >     END > PROCEDURE FIND >   BEGIN >     GET CUSTOMERS SEQUENTIAL >     GET ORDER_MASTER OPTIONAL >     END 
Yet it does. Why? 
How can I declare the FILE statement to not place an OPTIONAL on GET ORDER_MASTER? 
Thanks 
Kind regards, 
--- Fernando Olmos Senior Analyst Programmer HPA – A Salmat CompanyDirect: 02 9311 5411Fax: 02 9311 5166Mobile: 0434 879 784 www.hpa.com.au **********************************************************************
IMPORTANT
The contents of this e-mail and its attachments are confidential and intended
solely for the use of the individual or entity to whom they are addressed.  If
you received this e-mail in error, please notify the HPA Postmaster, postmaster at hpa.com.au,
then delete  the e-mail.
This footnote also confirms that this e-mail message has been swept for the
presence of computer viruses by Ironport. Before opening or using any
attachments, check them for viruses and defects.
Our liability is limited to resupplying any affected attachments.
HPA collects personal information to provide and market our services. For more
information about use, disclosure and access see our Privacy Policy at
www.hpa.com.au
**********************************************************************

_________________________________________________________________
Send a smile, make someone laugh, have some fun! Start now!
http://www.freemessengeremoticons.ca/?icid=EMENCA122
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20071113/c9d000ff/attachment.htm