<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6617.47">
<TITLE>RE: How to "ignore" records in a FIND procedure</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Just to add to this...</FONT>
</P>
<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">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).</FONT></P>
<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">Thanks</FONT>
</P>
<P><FONT FACE="Arial"></FONT> <FONT SIZE=1 FACE="Tahoma">-----Original Message-----</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">From: </FONT></B> <FONT SIZE=1 FACE="Tahoma">Fernando Olmos </FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">Sent: </FONT></B> <FONT SIZE=1 FACE="Tahoma">Monday, 21 August 2006 2:04 PM</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">To: </FONT></B> <FONT SIZE=1 FACE="Tahoma">powerh-l@lists.sowder.com</FONT>
<BR><B><FONT SIZE=1 FACE="Tahoma">Subject: </FONT></B> <FONT SIZE=1 FACE="Tahoma">How to "ignore" records in a FIND procedure</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Hi everyone.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">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?</FONT></P>
<P><FONT SIZE=2 FACE="Arial">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 ?</FONT></P>
<P><FONT SIZE=2 FACE="Arial">i.e. Here is the rows on my screen ...</FONT>
<BR> <FONT SIZE=2 FACE="Arial">Account Number Name</FONT>
<BR> <FONT SIZE=2 FACE="Arial">1234 Customer A -- this customer has 20 detail records where all records are not invoiced</FONT></P>
<P> <FONT SIZE=2 FACE="Arial">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</FONT></P>
<P> <FONT SIZE=2 FACE="Arial">1236 Customer C -- this customer has 5 detail records where all records are invoiced.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I want to use some logic to only display CUSTOMER B in the cluster, on the screen.</FONT>
</P>
<P><I><FONT COLOR="#0000FF" SIZE=4 FACE="Arial">Fernando Olmos</FONT></I>
<BR><B><FONT SIZE=2 FACE="Arial">MIS</FONT></B>
<BR><B><FONT SIZE=2 FACE="Arial">Senior Analyst Programmer</FONT></B>
</P>
<P><SPAN LANG="en-au"><B><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">HPA</FONT></B></SPAN><B><SPAN LANG="en-us"></SPAN></B><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT FACE="Arial"><BR>
</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT COLOR="#000000" SIZE=2 FACE="Arial">Direct: 03 9217 5411</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><BR>
</SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT COLOR="#000000" SIZE=2 FACE="Arial">Mobile: 0410 382 857</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT FACE="Arial"><BR>
</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT COLOR="#000000" SIZE=2 FACE="Arial">Fax: 03 9217 5716</FONT><FONT FACE="Arial"></FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"> </SPAN>
</P>
<P><SPAN LANG="en-au"></SPAN><A HREF="file:///H:/Appdata/Microsoft/Signatures/www.hpa.com.au"><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><U></U></SPAN><SPAN LANG="en-au"><U><B><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">www.hpa.com.au</FONT></B></U></SPAN><SPAN LANG="en-au"></SPAN></A><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN>
</P>
<BR>
<pre>**********************************************************************
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@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
**********************************************************************
</pre></BODY>
</HTML>