<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6617.47">
<TITLE>Here's a challenge</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">Hi everyone</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I have dozens of QUIZ reports that utilise a USE file, which contains DEFINES for two date fields (c_date_start and c_date_end). The QUIZ programs will ask the user to input these dates at run time and use them to CHOOSE data based on an INVOICED_DATE field, which is a repeating index.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Unfortunately some passes in these reports do not reference tables that have the invoiced_date field as an index, so the report will produce an "*E* Not a linkitem of the primary file" error. This is actually ok, because most of the reports will still produce something, but as you and I know, it's not good programming practice to allow programs to give out error messages. The other thing too, is that this error gives users the wrong impression and they log calls all over the place thinking their system has crashed, etc.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">My question is this ...</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Is there a way to know in Powerhouse (or through an operating system variable?), that will say the pass that is currently running has these so-and-so indexes in the database? I was thinking that without changing the QUIZ reports, I could just change a few of the USE files, that ask for the date range, to have the smarts to be able to strip off the CHOOSE statement at the end of the use file. If I had some sort of indicator to say "this current pass DOES HAVE the invoiced_date as an index", then I could program in the USE file to re-create the same .TXT file without the CHOOSE in it. It will keep changes within the USE file and then I don't have to change each and every report to remove the last line in the TXT file.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">A sample TXT file is like this ...</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">define c_date_start date century included = 20060601</FONT>
<BR><FONT SIZE=2 FACE="Arial">define c_date_end date century included = 20060630</FONT>
<BR><FONT SIZE=2 FACE="Arial">choose invoiced_date 20060601 to 20060630</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">Any ideas on this guys?</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Thanks</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>