How to "ignore" records in a FIND procedure

[fernando.olmos at hpa.com.au]

Just to add to this... 

The way I've been trying to do it, is to place an INTERNAL call in the
FIND procedure to count the number of detail records and determine
whether the total is based on the requirements I need. This way I was
hoping to pass back to the FIND procedure a counter or a flag to say to
the GET... ignore this get or do get the record for the cluster (based
on the FOR MISSING clause).

Thanks 

 -----Original Message----- 
From:   Fernando Olmos  
Sent:   Monday, 21 August 2006 2:04 PM 
To:     powerh-l at lists.sowder.com 
Subject:        How to "ignore" records in a FIND procedure 

Hi everyone. 

How is it possible, with logic, to be able to ignore the occurrence of a
record being retrieved into a cluster, within a FIND procedure?

Obviously the ACCESS and SELECT clauses at the FILE definition level is
the quick answer, but what if you require complex logic to determine,
based on details records, whether a record in a cluster should be
included or not ?

i.e. Here is the rows on my screen ... 
        Account Number  Name 
        1234                    Customer A      -- this customer has 20
detail records where all records are not invoiced

        1235                    Customer B      -- this customer has 10
detail records (orders) where 9 of 10 are flagged as invoiced and the
last rec is not invoiced

        1236                    Customer C      -- this customer has 5
detail records where all records are invoiced. 

I want to use some logic to only display CUSTOMER B in the cluster, on
the screen. 

Fernando Olmos 
MIS 
Senior Analyst Programmer 

HPA
Direct:  03 9217 5411
Mobile: 0410 382 857
Fax:     03 9217 5716 

 <file:///H:/Appdata/Microsoft/Signatures/www.hpa.com.au> 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
**********************************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20060821/e2bed009/attachment.html