<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
Hi Fernando:<BR>
<BR>
You can modify FIND Procedure<BR>
and remove the OPTIONAL clause on the SECONDARY file.<BR>
<BR>
Or in <BR>
Procedure POSTFIND <BR>
BEGIN<BR>
IF NOT ACCESSOK <BR>
THEN PUSH NEXT ; I am not exactly certain of this syntax<BR>
; The idea is to get the next primary record<BR>
END<BR>
<BR>
Regards,<BR>
Peter Bateman<BR>
<BR>
<BR> <BR>
<BLOCKQUOTE>
<HR>
From: fernando.olmos@hpa.com.au<BR>To: powerh-l@lists.sowder.com<BR>Subject: Stupid question about Primary and Secondary<BR>Date: Wed, 14 Nov 2007 11:27:34 +1100<BR><BR>
<META content="Microsoft SafeHTML" name=Generator>
<FONT face=Arial size=2>I thought that the following code would make the ORDER_MASTER table *not* optional!</FONT> <BR>
<FONT face=Arial size=2>> screen ert</FONT> <BR><FONT face=Arial size=2>> file customers in isdb</FONT> <BR><FONT face=Arial size=2>> file order_master in isdb secondary</FONT> <BR><FONT face=Arial size=2>> build list detail</FONT> <BR>
<FONT face=Arial size=2>> PROCEDURE PATH</FONT> <BR><FONT face=Arial size=2>> BEGIN</FONT> <BR><FONT face=Arial size=2>> LET PATH = 1</FONT> <BR><FONT face=Arial size=2>> END</FONT> <BR><FONT face=Arial size=2>> PROCEDURE FIND</FONT> <BR><FONT face=Arial size=2>> BEGIN</FONT> <BR><FONT face=Arial size=2>> GET CUSTOMERS SEQUENTIAL</FONT> <BR><FONT face=Arial size=2>> GET ORDER_MASTER OPTIONAL</FONT> <BR><FONT face=Arial size=2>> END</FONT> <BR>
<FONT face=Arial size=2>Yet it does. Why?</FONT> <BR>
<FONT face=Arial size=2>How can I declare the FILE statement to not place an OPTIONAL on GET ORDER_MASTER?</FONT> <BR>
<FONT face=Arial size=2>Thanks</FONT> <BR>
<FONT face=Arial color=#0000ff size=2>Kind regards,</FONT> <BR>
<FONT face="Courier New" size=2>---</FONT> <BR><SPAN lang=en-au><B><FONT face=Arial size=2>Fernando Olmos</FONT></B></SPAN> <BR><SPAN lang=en-au><FONT face=Arial color=#808080 size=2>Senior Analyst Programmer</FONT></SPAN> <BR><SPAN lang=en-au><B><FONT face=Arial color=#000080 size=2>HPA</FONT> <FONT face=Arial color=#0000ff size=2>– A Salmat Company</FONT></B><BR><FONT face=Arial color=#808080 size=2>Direct: 02 9311 5411<BR>Fax: 02 9311 5166<BR>Mobile: 0434 879 784</FONT></SPAN> <BR><SPAN lang=en-au></SPAN><A target=_blank><SPAN lang=en-au><U></U><U><B></B></U><U><B></B></U><U><B><FONT face=Arial color=#0000ff size=2>www.hpa.com.au</FONT></B></U></SPAN></A><SPAN lang=en-au></SPAN> <BR><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></BLOCKQUOTE><br /><hr />Send a smile, make someone laugh, have some fun! <a href='http://www.freemessengeremoticons.ca/?icid=EMENCA122' target='_new'>Start now!</a></body>
</html>