<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META content="MSHTML 6.00.2900.2912" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff size=2>But
that is precisely what I am trying to avoid - i.e.: not changing the actual QUIZ
reports themselves.</FONT></SPAN></DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff size=2>The
QUIZ reports look like this ...</FONT></SPAN></DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff
size=2>..</FONT></SPAN></DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff
size=2>..</FONT></SPAN></DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff size=2>@if
monthend</FONT></SPAN></DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff size=2>use
mipssc5a.qzs nol ;produces mipssc5a.txt containing two date
defines and a CHOOSE</FONT></SPAN></DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff
size=2>@else</FONT></SPAN></DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff size=2>use
mipssc5b.qzs nol ;produces mipssc5b.txt containing two date
defines (for different default dates) and a CHOOSE</FONT></SPAN></DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff
size=2>@endif</FONT></SPAN></DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff
size=2>..</FONT></SPAN></DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff
size=2>..</FONT></SPAN></DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff size=2>access
table1 link to table2 etc ;table1 has invoiced_date as an
index</FONT></SPAN></DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff size=2>@if
monthend</FONT></SPAN></DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff size=2>use
mipssc5a.txt nol ;this has a CHOOSE</FONT></SPAN></DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff
size=2>@else</FONT></SPAN></DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff size=2>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff size=2>use
mipssc5b.txt nol ;this also has a CHOOSE</FONT></SPAN></DIV>
<DIV><SPAN class=795415623-20072006>@endif</SPAN></DIV></FONT></SPAN></DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff
size=2>..</FONT></SPAN></DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff
size=2>..</FONT></SPAN></DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff size=2>access
table3 link to table4 etc ;none of these tables have
invoiced_date as an index or they could not even reference the column
itself.</FONT></SPAN></DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff size=2>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff size=2>@if
monthend</FONT></SPAN></DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff size=2>use
mipssc5a.txt nol ;this has a CHOOSE</FONT></SPAN></DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff
size=2>@else</FONT></SPAN></DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff size=2>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff size=2>use
mipssc5b.txt nol ;this also has a CHOOSE</FONT></SPAN></DIV>
<DIV><SPAN class=795415623-20072006>@endif</SPAN></DIV>
<DIV><SPAN class=795415623-20072006></SPAN> </DIV>
<DIV><SPAN class=795415623-20072006>;QUIZ does not crash at this point, but
shows *E* error message</SPAN></DIV>
<DIV><SPAN class=795415623-20072006></SPAN> </DIV>
<DIV><SPAN class=795415623-20072006></SPAN> </DIV>
<DIV><SPAN class=795415623-20072006></SPAN> </DIV>
<DIV><SPAN class=795415623-20072006>So as you can see the QUIZ program uses the
SAME txt file all along, but I want the TXT file to be altered (take off the
CHOOSE line at the end) for those passes that do not need it.</SPAN></DIV>
<DIV><SPAN class=795415623-20072006></SPAN> </DIV>
<DIV><SPAN
class=795415623-20072006>Thanks</SPAN></DIV></FONT></SPAN></DIV></FONT></SPAN></DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=795415623-20072006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Brett.Greiner@synoptix.co.nz
[mailto:Brett.Greiner@synoptix.co.nz] <BR><B>Sent:</B> Friday, 21 July 2006 9:22
AM<BR><B>To:</B> Fernando Olmos; powerh-l@lists.sowder.com<BR><B>Subject:</B>
RE: Here's a challenge<BR><BR></FONT></DIV>
<DIV dir=ltr align=left><SPAN class=596341923-20072006><FONT face=Arial
color=#0000ff size=2>What about adding a switch (cc={NO_INVOICE_DATE}) to the
report so when it runs the invoice code in the use file can be ignored. That is,
if the QUIZ program is not compiled.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=596341923-20072006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=596341923-20072006><FONT face=Arial
color=#0000ff size=2>Brett</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
powerh-l-bounces+brett.greiner=synoptix.co.nz@lists.sowder.com
[mailto:powerh-l-bounces+brett.greiner=synoptix.co.nz@lists.sowder.com] <B>On
Behalf Of </B>fernando.olmos@hpa.com.au<BR><B>Sent:</B> Friday, 21 July 2006
11:10<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> Here's a
challenge<BR></FONT><BR></DIV>
<DIV></DIV><!-- Converted from text/rtf format -->
<P><FONT face=Arial size=2>Hi everyone</FONT> </P>
<P><FONT face=Arial size=2>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 face=Arial size=2>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 face=Arial size=2>My question is this ...</FONT> </P>
<P><FONT face=Arial size=2>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 face=Arial size=2>A sample TXT file is like this ...</FONT> </P>
<P><FONT face=Arial size=2>define c_date_start date century included =
20060601</FONT> <BR><FONT face=Arial size=2>define c_date_end date century
included = 20060630</FONT> <BR><FONT face=Arial size=2>choose invoiced_date
20060601 to 20060630</FONT> </P><BR>
<P><FONT face=Arial size=2>Any ideas on this guys?</FONT> </P>
<P><FONT face=Arial size=2>Thanks</FONT> </P>
<P><I><FONT face=Arial color=#0000ff size=4>Fernando Olmos</FONT></I>
<BR><B><FONT face=Arial size=2>MIS</FONT></B> <BR><B><FONT face=Arial
size=2>Senior Analyst Programmer</FONT></B> </P>
<P><SPAN lang=en-au><B><FONT face=Arial color=#0000ff
size=2>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
face=Arial color=#000000 size=2>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 face=Arial color=#000000 size=2>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 face=Arial color=#000000
size=2>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
face=Arial color=#0000ff size=2>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><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>